Inserting a Table into a form cont...

  • Thread starter Thread starter James
  • Start date Start date
How would I get it to relate to a record as well?
Click to expand...

What do you mean by "it"?

I'm sorry, James, but your questions are just too cryptic for me to
figure out what you are asking; or you're working from a different set
of assumptions about how Access works.

Could you explain:

- What tables you want to see on this form
- How they are related
- How you want to see the data in the tables displayed
 
Ok then I would like a table in the form that has values
along the top and down the left hand side..

For Example:

Value 1 Value 2 Value 3 Value 4

SubValue1 tickboxhere tickboxhere tickboxhere
SubValue2 tickboxhere tickboxhere tickboxhere
SubValue3 tickboxhere tickboxhere tickboxhere
SubValue4 tickboxhere tickboxhere tickboxhere

Then when the tickboxes are checked or no checked then
they are saved to the appropriate record.

Does this help any?

I have some fields above and below my table so it will be
inserted as a sub form.

Is this possible?

If so how?

Many Thanks

James
 
Ok then I would like a table in the form that has values
along the top and down the left hand side..
Click to expand...

OK... as I suspected, it was clashing jargon.

A Table, in Access, is the basic storage medium for data; if you open
the database the first tab on the database window is the list of
Tables. I was assuming that's what you meant.

You're talking about "a table" in common English, not the technical
term!
Does this help any?
Yes.

I have some fields above and below my table so it will be
inserted as a sub form.

Is this possible?
Click to expand...

It's difficult to have it updateable. You can do it with a Crosstab
query but only for data display.

If your table is normalized properly, and you want this appearance,
you will need to either use an unbound Form and write VBA code to poll
through all the checkboxes, writing the data out to the tall-thin
table; or use a denormalized wide-flat table bound to the subform, and
write the data out to the normalized table using an Append query.
 
Back
Top