Summary Table



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.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

summaries of summaries.. 1
Summary 1
system summary 1
report summary 1
summary query 5
Summary Sheet 1
Summary query, sum by 1
Sorting in a summary report 2