开发者

How can i set a form with multi occurence from an another table in Access

开发者 https://www.devze.com 2023-02-05 00:48 出处:网络
lets assusme that in Access i have two table : Parent(id,first_name,last_name) Child(id,first_name,last_name,parent_id)

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

0

精彩评论

暂无评论...
验证码 换一张
取 消