Search results

Also, when I do the colours for each carpet, do I put 40 colour fileds on the product table or should I create a colours table and somehow relate that

Hi Paul thanks for the reply. Well basically I have made a form with all the product data at the top from the Products table and a subform (datasheet view) pulling across the supplier field along with supplier terms and price info from the supplier table but it's not doing anything, I can't...

Hi all. I have re-designed my database. Initially I had my products over 8 tables which represented 8 product groups because the attributes for each group are different. Now I have just one tblProducts and I've built my 8 forms from queries which separate the groups. Trouble is, Ive...

Thankyou Stopher & Cronk. Ok here goes, my tables look like this tblSuppliers tblProducts tblProduct_Sales tblSales PK Supplier_ID PK Product_ID FK Product_ID PK Sales_ID Supplier_Name FK Supplier_ID FK Sales_ID...

Hi fellow Accessers. I'm creating a database for a carpet firm I work for. Please excuse my naivety, I'm 54 and self taught. We have thousands of samples and thousands of products. I've got to the stage where I have Produced a navigation form which kind of works so that I can input new...

thanks jdraw I can't send a pic of my relationships, only 5 posts

Samples Project Hello all, please be gentle with me. I’m 54, self-taught and don’t want to frustrate anyone but will need walking through in baby steps. I work in a small carpet shop We have hundreds of products and thousands of sample. I’ve been trying to get a database together to handle the...

Thankyou Chris, I get it by generalising the names of the first few address fields you allow for unusual addresses and only define the latter constant ones. Also thanks for using the word "Flag" as that was what I was thinking. I can now have Retail, Trade, Supplier, Reps, Staff, as flags all...

Thanks for the response my friends, I'm still working on it and also getting to grips with Dreamweaver, I was a confirmed Frontpage man but have to change so apologies for the delayed reply, I'm further developing the database I have but still struggle. My sincere thanks to those that replied I...

Hi, I'm sure you've all had this one and are probably sick of explaining it but I just can't seem to get it to work. Access 2007, Windows XP sp3 I have created a form based on a table, to enter order details. I want to add a field that calculates the cost of a roll of carpet, [width] *...

Hi everyone, just joined. Although I've been bashing the books on Access for a while and managed to do most things I wanted to, I'm hitting a few stumbling blocks now as I further develop a database for the small carpet firm I work for. I've not long turned 50 and I'm determind to teach...