ACCESS question

I already created a table with my suppliers and all there info but I enter many of them  which are the same but in different locations what can I do to recreate it in a way when they are viewing the form I can have a "Suplier: box" that shows the name, and on the botton another box "sub site" where they can see the many locations that suplier chicago, la, new york... righ now I have the box of supplier shoiwing all of the same with many locations...

thanks in advance
Who is Participating?
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
create a form with subform,

set the Master Link field and  the Child Link field to the corresponding  fields

see this demo

Create a form that contains a subdatasheet
Or have another field with address/city, and also display that field.

You can also set the controlsource to concatenate the two fields.

|ABC Traders |NYC|
|Fosters Beer|MEL|

Setting a textbox's control source to
=tradingname & " - " & city

Open in new window

should display "Fosters Beer - MEL"

There are loads of solutions to this one, and it really depends on how you want to lay out your form.
gabgarAuthor Commented:
sample like this
I think it would be much easier to help if you could upload a sample .mdb - Is this possible?
gabgarAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.