Easiest Way Do Do This??
May 16, 2007
Hello folks-
I've tried to search for a solution to my problem, but I'm not sure how to phrase it to get a response. The problem:
I have a listbox that displays columns from a query. I would like to use the listbox to populate textboxes that relate to the same row (record). I’ve done it before, but the problem is that the query is run from a table that has no primary key. I’m not sure how to reference the correct record in the listbox without a key.
Is there a way to add a primary key to a query?
Cheers to anyone who can help. -Tom
View Replies
Jan 25, 2006
Hello all,
in your oppinion which would you say was easiest to control through forms, more information per table, or
more tables with less information in each?
Thanks
View 10 Replies
View Related
Feb 1, 2008
This is probably blindingly obvious but I'm unsure about it.
We'll refer to three tables, call them Table X, Table Y and Table Z.
Basically, I have a database with 10 tables. Table X links to Table Y via the Primary Key. Another field in Table X has a relationship with the Primary Key in Table Z (a foreign key).
Now, does the field in Table X that has a relationship with the primary key in Table Z need to be the primary key as well?
Put another way, does Table X need two primary keys?
View 1 Replies
View Related
Feb 5, 2008
I am trying to filter information in a table like you can filter information in columns in Excel. For example, if I have a table with data in it like dates and times and I wanted to filter to find all records with the date of 2/5/2008, how could I do that easily? Can it be a drop down box like in Excel. I'm making a program for someone, and I don't want for them to be able to change anything in the program so I have disabled viewing of some toolbars, besides, the filter button in the toolbar never does what I want it to do.
Thanks!
View 1 Replies
View Related
