subtable

[kgray]

Hi
i have a small access program set up and it all works except one item, there is a sub table that we would like to add in information relating to the order number etc:

order number 1

sub table would have j number 12345

allocation 5

and j number 56789

allocation 25

order number 2 (new record)

could have j number 148

allocation 1

j number 2143213

allocation 12345555

j number 86868

allocation 34

etc



then when you move between each order the information in the table will show the specific information relative to the order number
at the moment when you move from record to record it clears the fields but enters the information into a table

hope this makes some sort of sense

any assistance would be gratefully received

best regards

kev
p.s.if it would i could attach a copy of the database

 

[neileg]

You mean like this?

 

[kgray]

thanks

hi neil
thats exacly what i'm trying to do
attached is the database i'm trying to do it in, please could you explain what you did
many thanks
kev

 

[neileg]

For reasons I don't understand, I can't download attachments this moring, so I can't see your database.

What I did was as follows:

tblOrder has a primary key
tblOrderlines holds the relevant key value, OrderID, from tblOrder as a foreign key so you know which lines relate to which order
I created a form based on a query that pulls out the data from tblOrder
I created a subform in continuous forms layout based on a query that pulls data from tblOrderlines
With the main form open in design view, I dragged the subform onto the main form
I selected the subform object in the mainform desgin view and opened the Properties sheet. I set the master and child fields to OrderID

That's it.

 

[mahen]

Hi Neil & Kev,
I was talking about in db1.mdb. When you open tblOrder you get + sign. when you click the + sign you get another sheet contain following fields. OrderLineId, Jnumber, Allocation.
1. What is the purpose of this format. (with + sign) table?
2. How do I create this? (Does this come when you have the relationship)?
Can you explain in detail please.
Thanks.
regards,
- Mahen

 

[neileg]

Hi Neil & Kev,
I was talking about in db1.mdb. When you open tblOrder you get + sign. when you click the + sign you get another sheet contain following fields. OrderLineId, Jnumber, Allocation.
1. What is the purpose of this format. (with + sign) table?

This enables you to see the related data at table level.

2. How do I create this? (Does this come when you have the relationship)?

Yes. If you create the relationship in the relationship diagram, you get this feature.