Relationships

[abbey459]

Okay I’m in access and I’m trying to link tabs and I’m having issues.

My spreadsheet looks kind of like this

Vendor Products Subproduct1
Subproduct2

Leehigh Metals Shop Supplies STUCK


So I figured out how to create a table and do a drop tab under products to
have a list of products we use. But now I need to create and link tables so
that when I choose shop supplies for instance, a new tab will come up under
subproduct1 and subproduct2 with a list of shop supplies.

 

[Gina Whipp]

abbey459,

Slightly confused here...

You say you are in Access BUT you then go on to say... "My spreadsheet...".
Access has tables not spreadsheets, so are you in Excel looking at a
spreadsheet OR in Access linked to a spreadsheet OR treating an Access talbe
like a spreadsheet (won't work)?

Then you say... "...link tabs..." and "...drop tab...". Are you trying to
link to multiple spreadsheets OR using subdatasheet view in Access OR in
Excel?

Going to need a wee bit more information... Please provide your table
set-up in Access OR if you are linking to an Excel spreadsheet then tell us
that.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm