multiple tables, composite keys

[atledreier]

Hello!

I have a database where my client have a set spec for how the tables
are laid out. My data needs to be imported into my client's database,
so they need to match. This means that any change to the database and
table structure is 'prohibited'. The relationships are not set by my
client. It also means that the database structure is somewhat thought
through, so it's probably my inexperience that prevent me from doing
what I need.

I have data in my lists that needs to go into multiple tables in the
database.

My table structure (* is primary key):

tblTag
flag
*location
*tag
description
category
function_code
.....

tblTag_format
flag
*location
*tag
node
panel
.....

There are several more tables like tag_format, and also other tables,
but the behaviour is similar to tag_format.

Now, what I need to do is this:
I need a datasheet that list all the tblTag fields, along with the
tblTag_format fields, and fields from other tables, like this:

flag
location
tag
description
category
function code
....
node
panel
....

Now, in my limited experience, this seems like there is a one to one
relationship between the tables. One and only one entry in
tblTag_format table for each entry in tblTag. When I set this
relationships I get a message 'no unique index found for the
referenced field of the primary table.'

I also need to be able to enter data in this form. So if I enter node
or panel data for a tag, tblTag_format get a new entry.

Please let me know if this post belong in the table or query group
rather than here.

- Atle

 

[atledreier]

Ok, I ditched the composite keys, the tag numbers are unique anyway.
Now I have another problem. Will make a separate post.