Linking forms via tables

[moles]

I have created one form which stores daily data in table A creating one record a day. Form 2 has a subform in it which stores multiple records of data in table B. I want to be able to run reports pulling data from both tables on a given day. I basically want my record stored in Table A to have a unique Auto Number. The records I store in table be, even if multiple records I want to have the same auto number that was given to the record in stored in table A. How can I do this.

 

[SBendBuckeye]

Give record B its own unique key and also include in record B the key from record A. Then you can go into the Linking area and establish a one to many relationship from A to B by clicking on the field in record A (the one side) and dragging it over to and across the field name in record B (the many side). If you want all table B records to be deleted when a table A record is deleted then check the referential integrity checkboxes.

Once this relationship is established, it will automatically show up whenever you design a query with the 2 tables.

Good Luck!

If you are just getting started or moving to a new level, don't forget your local library as a resource.