I started working on my first Access Dbase about a week ago, Thanks NeoPa for the initial help. Now I am trying to create a form. What I would like to do is have one form that I can fill out. The table the form is going to has 3 fields Office ID, Phone Number (Primary Key), and Purpose. I would like to be able to have the form so I can put the Office ID in 1 time and then fill in the Phone Number and Purpose for the different numbers in that office. So far I have a form that "looks" like what I want but when I put data in the same data populates all the fields. Please help. Also from reading other posts it seems as metadata is something that you might want to see. If you could give me a quick explanation how to get it I will be happy to post it.
-
-
MetaDataOriginally posted by Kasghost
TableName
PrimaryKeyName
OtherFieldNames
In this case you need a main form and a subform. The main form would be based on the Office table and the subform on the Phone table. This would allow you to enter records in the Phone subform for each record in the Office Mainform.
Mary -
Ideally, your MetaData should look something like this.
You would need to fill in the blanks and amend any errors.
Use the Reply button on this post to get the code that you can amend to show it like this.
Code:[b]Table Name=tbl???[/b] [i]Field; Type; IndexInfo[/i] PhoneNumber; Text; PK OfficeID; Number; FK Purpose; ???
Comment
Comment