Add a table to a form

[hoofit]

I have a form based on one table. I need to bring in another table. How is this done or is it too late?

Thank you

 

[boblarson]

My question is WHY? How does this new table relate to the existing one? If it is a true one-to-one table (you can only have one record in the second table for the one in the first) then you can create a query which links the two by the proper ID (ID in the first table should be FOREIGN KEY in the second).

If the second table is the many side of a one-to-many then you need to use a MAIN FORM for the first table and a SUBFORM for the second.

So, essentially we need more information.

Bob Larson
Free Access Tutorials and Samples:

http://www.btabdevelopment.com

 

[hoofit]

Hi boblarson,
Thank you for responding. The 'new table will be a lookup table for the first one. I have a form with quite a bit of work completed and the second table was an after thought. The second table will be used to store links to photos on a hard drive. I have tried to reference the record source of a new textbox on the form, for example, and get the error. Hopefully I do not need to start from square one. Seems like a major mistake, I may scrap the idea. Could you assist?

Thank you

 

[MajP]

The second table will be used to store links to photos on a hard drive.

This sounds like you want to add a subform.

http://office.microsoft.com/en-us/a...a-subform-a-one-to-many-form-HA010098674.aspx

 

[randy700]

How about a combo box based on the second table?

Randy