G
ga.irving
I have 3 tables with their own PK and input forms. I want to group
them on a forth summary table with its own PK and 3 FK, one for each
table. The summary sheet may or may not use all the other tables. I
am having real problems walking through inputing data.
What I want is to go to the summary input form, click a button for one
or all of the buttons depending on the Project specification, this then
brings up the relevant forms these I then input and comback to the
summary form.
I currently canot enter data into the summary form as I have no subform
data. and I cant enter subform data as I have no PK in the summary
form. I am using referential integrity on all links.
Any sugestions or solutions welcomed.
them on a forth summary table with its own PK and 3 FK, one for each
table. The summary sheet may or may not use all the other tables. I
am having real problems walking through inputing data.
What I want is to go to the summary input form, click a button for one
or all of the buttons depending on the Project specification, this then
brings up the relevant forms these I then input and comback to the
summary form.
I currently canot enter data into the summary form as I have no subform
data. and I cant enter subform data as I have no PK in the summary
form. I am using referential integrity on all links.
Any sugestions or solutions welcomed.