Creating a form with two different tables.

[onemoretime]

I have a form that gets information from about 200 fields in a table. I want to put a text box that gets its information from another table. How can I do this? The Record source has the table name of Table1. Do I need to put something in the Control Source of the new text box?

 

[DougP]

First of all be aware that there is a limit as to the number of items you can put on a form. or report.
Also Queries have a character limit.
Not to mention the amount of memory (RAM) that it will take to load it.

You need to look at a term called Database "Normalization".
Which is database design where like items are kept in together in separate tables.

Case in point

Table name Data it contains
------------------------------------------------------------
Customers CustID, Name, Address, etc
Invoices InvoiceNum, Date, Total Price, etc
Invoice Details InvoiceNum, PartNum, Qty, etc
Inventory PartNum, Description, VendorID, etc
Vendors VendorID, Name, Address, Payment Terms,

5 tables needed to make a Invoice program

So instead of having one table contain all of the above data. 5 tables contain just what they need. It takes up FAR less disk space and far less RAM and is much easier to manage and very fast to search.

OK


DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.
Or visit my WEB site

http://www.barcodeone.com

 

[elizabeth]

Once you normalize your tables (you can find it under Help), as DOugP suggested, write a query that contains all the fields you are interested in. Then use Access's form wizard to build a form based on that query. This is the easiest way. However, if you have a complex form that is working fine and would be a hassle to recreate, you can just create the underlying query and then do just as you guessed. Change the form's RecordSource to the name of your new query. After you have the desired fields available due to changing the RecordSource, then add the new textbox from your fieldlist icon on the toolbar - your new field will be one of your choices.