link one form to many tables

[tomhughes]

I would like to link one form to many tables. I am using a combo box to select the table to link to. The table that is linked to shows up in a text box on the form. Is this possible? If possible I would like to use Visual Basic programing.

 

[fneily]

Why? You don't like making forms for each table?
More technical questions: Each table should have DIFFERENT fields. Ever hear of Normalization? So, if the user selected a table from a dropdown, the textboxes would have to reflect the underlying source. So, you could create a form with all the fields of every table and then hide them. Then when someone selects a table, change the source property for the form and make just those fields visible. Waste of time.
What are you trying to accomplish???

 

[tomhughes]

fneily - It sounds to me like you are mad at my request. Is that true ???

 

[AlexCuse]

Why do you have these ten tables? Could the data from them not be stored in a single table (if you have same columns, the answer is yes). Then you could choose a filter for what records are actually displayed via your drop down list.

Good Luck,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[tomhughes]

AlexCuse - Actually I could have 26 tables, or I could put everything into one large table. I'm not sure of the pros and cons of the two different ways to do this. Evidently my suggestion of viewing two tables on one form is not the way things are done, going by fneily's response.If I have one large table I need to view two different records from different fields at the same time.If I have 26 tables I want to view two different tables on one form. Do yoiu have any suggestions.

 

[PHV]

Have a look here:

http://r937.com/relational.html

And read careully this: FAQ181-2886