Help building a list (newbie)

[DeltaWolf7]

Hi,

I am hoping this is the right place to find some help.
I have just started access (2003) and i am trying to build a list.
Let me explain.

I have a table that contains
cartcode, description, price

and another containing
manufacturer, model

I then created a new table that links these tables together so that if i click the little + next to a cartcode i can see a list of models linked with that cartridge.

What i want to do though is create a query/table/anything that will create me a list of cartridges and then in the second column a list, hopefully seperated by a comma or all the printers models related to that cartridge.
I hope that makes sence.

So my question is how do i create the list which included related printers?

Thank you

 

[ColinEssex]

Search for cascading ComboBoxes, you select from the first ComboBox and then the 2nd ComboBox will list all items only associated with the first choice.

Col

 

[DeltaWolf7]

Thank you for the quick reply.

Would cascading ComboBoxes also work within a query?
The reason I am asking is because what i am trying to do is build a list that I can export to a tab delim file and import to our website. (oscommerce/easy populate)

Thank you

 

[ColinEssex]

I may be wrong here but I get the impression you are entering data directly into a table.

If so, you should be using a form with a query as its recordsource.
Your tables should be linked in the relationships part so that the database works properly.
You can then use the Comboboxes in the form, get the data entered, then use a query to interrogate the data in order to export it to whatever you need.

Col

 

[DeltaWolf7]

Almost right. The data I already have. Its complete and does not need to change. what i am trying to do it create a query that can output a view that is formatted in a way that i can use it with our website.

I hope this makes sence to you.

Database Design
-----------------

Cartridges
========
(P) CARTCODE - TEXT - 50
CARTDESC - TEXT - 255
CARTPRICE - NUMBER - DOUBLE, CURRENCY

Manufacturers
===========
(P) MANUFACTURERNAME - TEXT - 50

Printers
======
(P) PRINTERMODEL - TEXT -255
PRINTERMANUFACTURER - TEXT - 50

Group
=====
(P) ID - AUTONUMBER
GROUPID - TEXT - 255
LINKEDCARTS - TEXT - 255


Relationship Design
-------------------

Cartridges.CARTCODE one to many Groups.LINKEDCARTS
Groups.GROUPID one to many Printers.PRINTERMODEL (Enforce update/delete)
Printers.PRINTERMANUFACTURER one to many Manufacturers.MANUFACTURERNAME