gabgar
asked on
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 has...like chicago, la, new york... righ now I have the box of supplier shoiwing all of the same with many locations...
thanks in advance
thanks in advance
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
sample like this
Sample001.pdf
Sample001.pdf
I think it would be much easier to help if you could upload a sample .mdb - Is this possible?
ASKER
thanks
You can also set the controlsource to concatenate the two fields.
tblSuppliers:
--------------------------
|Tradingname|City|
--------------------------
|ABC Traders |NYC|
|Fosters Beer|MEL|
--------------------------
Setting a textbox's control source to
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.