Hi, i am new to access and have a problem linking the master/child fields.
My main form consists of a tab strip that has 8 tabs with a subform on each. On each form i have a common field S_REF (student Reference) that is common to all but can't seem to display the data from the tables. If i pull up a form on its own (not via the main form) it does display the data! how do i link them master/childs fields to get the subforms on the main form to display the data?? any suggestions would be appreciated!
yip, i have done that already but it doesn't work. Is this because each subform has a different table for itself? as there are multiple tables, which should i put as the record source on the main form?? Of the 8 tables, one has data that already exists! i have only had about 2weeks tuition on access, maybe i am in way over my head?
i do! each table has the S_REF and are linked together by this field in my relationships. However most of my relationships are one to one as the project is for a Student Services Fund and each student can only apply once. Would this affect it?
create the form to be the subform
create the master form
either drag and drop or use the subform tool and select from the list to put the subform onto the master
make sure the link master and link child properties are set