Basic Q's? on how Forms Process Entered Data.

[tucker1003]

Okay these questions may be basic, but I keep running into walls when I am setting up my forms. To start I played with Access 2007 creating a database for my store to have my employees enter product data. It wasn't the best design, but it worked even though it was 1 table 30 fields. Once I found out
Access 2010 did web databases I switched. I want this data to be accessed through my Ipad via web browser. I have 3 ebooks that I've been referencing for Access, but am still getting stuck.

Currently I'm making 2 databases side by side. One web database and one NON web database, since web has certain restrictions I can use the NON web design to understand workings and properties to translate to the web database. I will show you my design which I had someone help me with then ask the basic questions.

Parent Company
ID(PK)
ParentCoName

Manufacturer


ID(PK)
ManufactName
ParentCoID(FK)

BrandLine
ID(PK)
BrandName
ManufacturerID(FK)

Product
ID(PK)
ProductName
BrandNameID(FK)
(20 other fields relevant to the Product)

SizePrice
ID(PK)
Size
Price
ProductNameID(FK)

Ok, silly questions. MY Form is setup using TABS each table to a tab. I don't understand how these entries are processed? I tried a run through entering a ParentCoName, ManufactName, BrandName, ProductName and all of its proceeding info, a size and price. How do I move to the next entry in all of these tables? When I had one table in my 2007 design I had a ADD NEW button which accomplished this, but not found in my 2010, or something is preventing me from using it. I would like my employees to have to enter a Parent Company once and then be able to just choose it later as needed. I understand my foreign keys need data to refer back to its primary key, but currently I'm choosing the integer ID # instead of the actual text name, which I rather have because my employees wont remember what the numbers reference. With a Combo Box as I understand I can have them enter new data or choose from old, I would prefer this method. Also, each Product will have at least 3 Sizes and Prices, a table
subform will work perfect, but will they have to enter ProductNameID each time? How can they see what it is if that is the case?

Thanks in Advance,

Nick

[orange]

Have you seen the free videos here
http://www.datapigtechnologies.com/AccessMain.htm

You'll probably get useful techniques from these.
or
http://office.microsoft.com/en-us/ac...001230049.aspx

[tucker1003]

Those will definitely help!! Thanks!