OliverWilton
Registered User.
- Local time
- Today, 15:11
- Joined
- Nov 25, 2008
- Messages
- 15
I'm very new to Access and it's my first attempt of building such a database, so if there any any hints or tips you can suggest on-top of my questions PLEASE! feel free to add your comments.
I have no idea how detailed you guys need me to explain it so i shall go quite thorough as i really need to solve this problem.
Basically, i have a "PRODUCTS TABLE" as the main table with all the fields inside of this. The primary key is the item number. I have many tables coming off of this table, these are:
BUYER
CLASSCODE
COMMODATION
GLG
ITEM
ITEM TYPE
MFG PURCH
ORDER POLICY
PLANNER
PLANT
PRICE CLASS
PURCH UOM
STACK
VAT
all of the primary keys in these tables appear in the PRODUCT table as a foreign key. So i think on the relationship side i'm fine.
When setting up a form, i have set it up so that the item number and description are being pulled up from the PRODUCT TABLE when really they should be being pulled from the ITEM TABLE, though i'm worried about this because the item number is the primary key in the PRODUCT TABLE and is also the primary key in the ITEM table. Though it hasn't caused any problems and they all hold referential integrity.
Anyway, i have alot of flat fields which just come from the PRODUCT TABLE and whatever is input into them fields just go straight into the PRODUCT TABLE.
On the form i also have combo boxes that get read from other tables using control source. So if for example item number 1 is selected, i have a combo box on the form to select the specific VAT for that item, which in the wizard i set that field to read from the VAT CODE table (for different levels of VAT) and in the control source it's being read from the PRODUCT table. This is all working fine in general, but the problem lies when i close the form.
I close the form fine, it automatically saves with no errors but then when i re-load the form, the item number is blank but all of the item number 1 fields that are filled in under item number 1 are still in the box!!
I felt it was important to tell you have it was set up for any suggestions and it might help the problem to be solved. I need to open the form with NO data inside of it, until the item number from (for now the combo box) has been selected.
I said (for now in the combo box) purposely because (rightly) i was pointed out that if the company was to have thousands of products, an item drop down box would be ludicrious which is obviously correct. So another thing i need help with is, how would i go about making that different so that i could just TYPE in the product ID? rather than making a combo box.
Sorry for the long post, i appreciate ANY help given to me. Hope this isn't too much to ask! Thanks for your time.
Oliver.
I have no idea how detailed you guys need me to explain it so i shall go quite thorough as i really need to solve this problem.
Basically, i have a "PRODUCTS TABLE" as the main table with all the fields inside of this. The primary key is the item number. I have many tables coming off of this table, these are:
BUYER
CLASSCODE
COMMODATION
GLG
ITEM
ITEM TYPE
MFG PURCH
ORDER POLICY
PLANNER
PLANT
PRICE CLASS
PURCH UOM
STACK
VAT
all of the primary keys in these tables appear in the PRODUCT table as a foreign key. So i think on the relationship side i'm fine.
When setting up a form, i have set it up so that the item number and description are being pulled up from the PRODUCT TABLE when really they should be being pulled from the ITEM TABLE, though i'm worried about this because the item number is the primary key in the PRODUCT TABLE and is also the primary key in the ITEM table. Though it hasn't caused any problems and they all hold referential integrity.
Anyway, i have alot of flat fields which just come from the PRODUCT TABLE and whatever is input into them fields just go straight into the PRODUCT TABLE.
On the form i also have combo boxes that get read from other tables using control source. So if for example item number 1 is selected, i have a combo box on the form to select the specific VAT for that item, which in the wizard i set that field to read from the VAT CODE table (for different levels of VAT) and in the control source it's being read from the PRODUCT table. This is all working fine in general, but the problem lies when i close the form.
I close the form fine, it automatically saves with no errors but then when i re-load the form, the item number is blank but all of the item number 1 fields that are filled in under item number 1 are still in the box!!
I felt it was important to tell you have it was set up for any suggestions and it might help the problem to be solved. I need to open the form with NO data inside of it, until the item number from (for now the combo box) has been selected.
I said (for now in the combo box) purposely because (rightly) i was pointed out that if the company was to have thousands of products, an item drop down box would be ludicrious which is obviously correct. So another thing i need help with is, how would i go about making that different so that i could just TYPE in the product ID? rather than making a combo box.
Sorry for the long post, i appreciate ANY help given to me. Hope this isn't too much to ask! Thanks for your time.
Oliver.
