Search results for query: *

I'm building an inventory database for my place of employment, and when entering inventory, you enter the Serial Number and Customer it is for on the form, and also the date recieved. Then on the SubForm, the Serial Number is already populated according to what you put in above it. Then you can...

I did that, couldnt find any. Is there any way to just delete all relationships?

Ive been creating my relationship for my new Inventory database, and everything seemed to be going well. I needed to change a field in my table, but it said I couldnt change it until I deleted it's relationship. I went to do that, but none of the relationships where there. I created them all...

Ok, the final table has been split into two as follows: tblInventory: Product SN (PK, serial number of product) Product (from drop down list, links to product table) Purchase Order Number Date Recieved tblLocation: Product SN Product Location (Restaurant name or In house, restaurant name...

Alright, two tables it is. I need help with the relationships, though. Primary keys, foreign keys, skeleton keys, one to many, many to one, one to one, many to many, I'm not sure how to manipulate the relationships correctly so the database works for us... Would someone lend a helping hand?

Really... I was almost sure all of the Access Wizards would tell me to split it up. Why would you suggest one, just out of curiousity

Hello all, My name is Justin and I work for a company in connecticut that sells Point of Sale Systems to restaurants. My father runs the company and I work here when I'm not in school, learning the ropes of the business and what not. Before I get into my Access situation, let me describe a...