many-to-one relationship

  • Thread starter Thread starter Bruce Baird
  • Start date Start date
B

Bruce Baird

I want to automatically create a table in excel based upon
a "many-to-one" relationship.
I have a table of inventoried items:
Asset# Desc Type Function PurDate etc

The "type" cell (field) is what I want to use as the basis
of the many-to-one. In other words, if there are a number
of "types" with the designation of LP, for instance, then I
want to have excel create a table displaying just the LP
records in my inventory table.

Hope this makes sense. Can it be done inside of Excel or
do I have to go "external" using Access or whatever.

Many thanks,
Bruce
 
Can you use Autofilter? or, if a separate table is needed, Advanced
Filter?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Indeterminate relationship in many-to-many table (Windows 10, Access 2016) 5
Understanding Many-to-Many Relationship 4
Access Scan a UPC on a txtfield on mainform & add to subform Please Help! 1
Multiple Many-to-Many relationships 8
One to one relationship 0
Excel Typed text appears in wrong cell 0
ms access relationship problem 1
Assistance with Many-to-Many Relationships 4

Back
Top