To edit a sub-table related to a main table

[roxytrading]

I'm a beginner in Database design so please bear with me for any mistakes. I am trying to design a database for Import/Export containers where I can also list the itemized products for each container.

I have designed two databases for this purpose. One header database with shipping information for each container and a details database that has "CTNR No." as the field that links to the header database. The relationship is One to Many (Header to Detail).

As I edit in the header table (not using forms), I'd like to have access to some type of sub-form that lists all the items that comes in this container. By default, this list should be hidden so I can have a better view of the whole bunch of containers.

I have seen a design where at the very beginning of the record it has a plus sign where you can click to show the corresponding list. Can someone help me out with this? I've also tried with subforms but I would prefer it to be editable in the actual database table.

Thanks a lot!

 

[dhookom]

You should crank up your development a bit and use only forms for editing your data. What you are asking for is easily implemented with a form and subform. The subform could be on the second page of a tab control on your main form.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[lespaul]

I think you could also use a little more understanding of databases. A database is a collection of tables (which I think is what you meant when you said:

I have designed two databases for this purpose. One header database with shipping information for each container and a details database

You should also read the Fundamentals document linked below for some basics on design.


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design