How can i set a form with multi occurence from an another table in Access
lets assusme that in Access i have two table :
Parent(id,first_name,last_name)
Child(id,first_name,last_name,parent_id)
How, step by step, to make a form based on the Par开发者_如何转开发ent table, so that whil adding a parent, i can also adding his children?
Any advise or any link will be great.
The easiest way is to use a feature called “Sub Forms”. This is designed to show this kind of parent/child relationship for example the line items on an invoice. To say me explaining how here is a link to a tutorial on the subject
http://www.google.co.uk/url?q=http://fisher.osu.edu/~muhanna_1/837/MSAccess/tutorials/subforms.pdf&sa=U&ei=Fkw1TfncHYuFhQf1sujdCw&ved=0CBcQFjAD&usg=AFQjCNHFGtzi9bew8Wowx9HiCQ6sccK5BA
精彩评论