G
Guest
I have downloaded a contact mamagement database template from the microsoft
website and want to use the form design for my own database.
I have created the tables and established the relationships but cannot get
the subforms to work in the same way.
There is a main form which includes 2 subforms based on a Calls Table.
Primary key in the calls table is call ID, tables are related by ContactID in
the Contacts table.
The first subform contains 3 fields and is in datasheet view
The second subform (which appears to act as part of the 1st subform)
contains a notes field and is in single form view.
I have checked the form properties of both subforms and the differences are
the default view settings and that the second subform has the Record
Selectors property set to No. The Link Child and Link Master Fields are set
to ContactID in the 1st subfrom and CallID in the second subform but I don't
know how to change this.
I have no previous programmming or code writing experience but really want
to be able to use this form.
Any help (simply expalined) would be appreciated
Jane
website and want to use the form design for my own database.
I have created the tables and established the relationships but cannot get
the subforms to work in the same way.
There is a main form which includes 2 subforms based on a Calls Table.
Primary key in the calls table is call ID, tables are related by ContactID in
the Contacts table.
The first subform contains 3 fields and is in datasheet view
The second subform (which appears to act as part of the 1st subform)
contains a notes field and is in single form view.
I have checked the form properties of both subforms and the differences are
the default view settings and that the second subform has the Record
Selectors property set to No. The Link Child and Link Master Fields are set
to ContactID in the 1st subfrom and CallID in the second subform but I don't
know how to change this.
I have no previous programmming or code writing experience but really want
to be able to use this form.
Any help (simply expalined) would be appreciated
Jane