Merge Fields in different records

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

Guest

Help I need to find a way of merging values from the same field in different
records.

I have a list of suppliers who supply different products, I have a table for
Suppliers details and a table with suppliers names and the main products they
supply, with each product being a different record.

I now want to display in the form the suppliers details and one field
showing all of the main products they supply.

The best way I can think of describing it is if you were grouping in a query
you would group by Where on all of the suppliers details and need a sort of
List option on the Product field, which you dont have.

Can any one think of a way I can get around this.

Thanks
Ceri
 
Hi, Ceri.

Any reason not to use a subform for the Products, linked by SupplierID to a
main form based on your Supplier table?

Sprinks
 
This was my original thought and might be what I have to settle on. But I
wanted to have a contiuous form which I dont think you can have when using
sub forms.
 
The default type of form for subform is Continuos, have you had a look at
the northwind.mdb that come with Access.

This will show you how to do it.


John A
 
I can get a continuous sub form but I cant get a continuous main form if I
have a sub form in it
 
You could use two subforms. The main form would be a single form
display of the suppliers. The first subform would be another bases on
the suppliers but in continuous display. I believe you would use the
on current event to move the main forms record in sync with the
subform. The second subform would be the list of products supplied by
the supplier current in the main form.
 
Back
Top