Subdatasheets

[Chose.cz]

Hello,
I'm sorry if this has been already discussed but I've been searching without result.

I have a table "A", with table "B" in it as a subdatasheet.
Now when i insert a new row into "A", i need a new copy of the table "B" to be created, meaning every row in "A" would have it's private copy of "B". Is there a way to do this? I don't insist on subdatasheet solution, i just need a new copy of B to be created and linked to any new record in A.

Any suggestions?

 

[KenHigg]

This is just a stab in the dark but I'm thinking you simply need to set up the table relationships for this to happen...

 

[Ron_dK]

I have a table "A", with table "B" in it as a subdatasheet.
Now when i insert a new row into "A", i need a new copy of the table "B" to be created, meaning every row in "A" would have it's private copy of "B". Is there a way to do this? I don't insist on subdatasheet solution, i just need a new copy of B to be created and linked to any new record in A.

What is the difference between the data in table A and table B.
If there ain't any, why would you have two tables with the same data ?

 

[Chose.cz]

What is the difference between the data in table A and table B.
If there ain't any, why would you have two tables with the same data ?

Say there is a record called "Nokia 6330" in A.
In B, there is a set of questions ("Do you like the color of the phone", "Are you satisfied with battery life", and so on) - about 350 of them, with many colums for answers. It would be impractical to have 350 columns in A, espetially with column names like "Are you satisfied with battery life".

Hope somebody can understand what I mean.

 

[Ron_dK]

Ok, that makes things clearer.
As suggested by Ken, why not make a query based on a relationship between the relevant field in table A and B.
For example :

table A :
Type ID ( FK)
Type description

Table B :
question ID (FK)
Question number
question description

Make a one to many relation between question ID and type ID and
make a query, which includes the relevant fields from table A and B.


Hth

 

[Chose.cz]

Thx

Thx, that works.
It isn't exactly what i had in mind, but id does the job.