Please help ...new to all this jazz

[Noodle7]

Hi
I need to create a database where there is one table where data is added however in this table there are a few other tables which are updated from this one table. For instance Supplier and Product when you add in the product and the supplier the supplier field will have a drop down box for the available suppliers and if it is not in the list then you can add it by just typing it in the field. This will update the Supplier table . Or do you have to add all the suppliers into the table and then make a query for the products table that includes the supplier table.

I just need a simple way of not rewriting the same thing over and over
but having all the fields available in one table ??
Hope I make sense

 

[elbweb]

for this to be simple, you are going to have to use the built in access form wizards, for you need to create the tables that you want, and build the relationships you want, and then use the form wizard to create subforms and have the data linked, and everything should work as you want, you might need to manually assign a few things, like the combo box, but it should be faily straightforward from there.

 

[Noodle7]

So I will create all my tables even if the table as two coloumns in it ...being ID and so eg Title... I actually have a few tables like that

Title ID
Title

and another table would be
Artist ID
Artist

third
category ID
category

Fourth
Product ID
Product Type
Product
Price

and need all of this to go into one table called Product List which contains Title, Artist , Product , Product Type , category , Price now I am not sure how to link them?

 

[Ron_dK]

need all of this to go into one table called Product List

Putting all the data from various tables into one table is not really the way to go. You should establish appropriate base tables , make the necessary relationships between them and create queries.
You might do a search on Normaliz(s)ation and referential integrity on this forum.