Tables-Forms???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I hope someone can give me a suggestion here - because I have tried
everything and I cant make this thing work.
I have one table that has information about "stores" (address ect - what
they sell - a description and so on) from this table I have created a form
with all this information on it each store has a contract number.

Each store however may have more than one branch - for example one store has
32 branches - I created another table with all the branch stores with their
address etc.

My question is as follows how can I make all the branch stores for a
specific store appear on the same form - (the problem is, is that I have to
enter each branch separately as I will need to create labels from this table
at one point otherwise I would have put them in the same column one
underneath the other using ctrl enter)

What I want is to create a link using the contract number as they key -

If someone can help me I would truly appreciate it!
 
Hi Arvin and thanks for your reply,

I must be doing something wrong - I created the subform but it does not
take the data from the table? it just shows me the contract number. Can u
maybe explain this in plainer words I must be missing something

B
 
Back
Top