Data Entry & Display

[mraxl]

I'm a newbie to the forum and to Access.... please forgive ignorance on my part.

I'm trying to create a data base with, basically, two tables. One is totally individual while the other has multiple references to the first. The second has One to Many relationship.

I have created an SQL query with both table parameters included.

I have also created a form that includes a tabbed form exclusively for data included in the second table. No subforms are used.

All of what has been done works fine. However, I have a couple of problems moving forward.

Problem#1 - I want to display ALL related records from second table when the record from the first table is selected.

As it is now, by incrementing the record selection at the bottom of the form, each individual record is displayed rather than the one master record with multiple sub-records from the second table.

I'm getting the impression that subform(s) must be used for this purpose??? what do I need to do?

Problem#2 - I would like to be able to enter a sub-record by pulling up the Master record (with all associated data) from the first table and be able to enter data into the second table from a blank form section.

As it is now, I must enter duplicate info into the form that is already in the first table then enter the new data into the second table.

If I use a combo box to select a record from the key in the first table only that field is changed.... I want all form fields from that key to change reflecting data from the associated key and have blank fields for the entry of data to the second table.



I apologize if the above is not clear.... let me know if more detail is needed. This would be the same as having a single "Customer" and recording individual "Purchases" for that customer. Appreciate any help that can be offered... TIA

[June7]

Problem #1 - Yes, use form/subform arrangement

Problem #2 - Should not be duplicating data, no reason to repeat the data in second table. The related info can be retrieved by joining the tables in queries. Again, use form/subform arrangement.

Subform probably in Datasheet or Continuous view. Enter new record at the end of the records listed.