Inventory -- auto deleting from table

[jmyers6572]

Hi everyone....a newbie to the forum and to Access. I use Access on a daily basis as an end user at work and am building my very first database for my woodworking business I started this year.

So what I am wanting to do is import my Excel inventory list to a table. Along with the categories I have in Excel, I have created inventory numbers for my products. Since I'm not exactly a businessman and accustomed to inventory systems, my inventory numbers just start with "AA" and go on up (I chose this as opposed to assigning numbers so customers aren't confused when they see a price tag).

Anyways, what Im doing is creating a Sales table and accompanying form for entering sales of each product. What I would like to happen is every time I make enter a record into the Sales form, I would like for the item to be deleted automatically from the inventory table.

I know enough to be very dangerous and really confuse myself to say that I believe I will need to make some big ole IIF statement/string. But I throw in the white towel here. I am utterly clueless. Can someone help? And yes, I will insult my own intelligence and would appreciate any 1st grade level answers. LOL

Thanks and Blessings...

Jay Myers, owner of It's Saw Good

[June7]

A well-designed db should not require deleting item just because its status has changed. Have you looked at template databases? The Northwind sales database is used extensively as a tutorial. http://office.microsoft.com/en-us/te...001228997.aspx

[orange]

I agree totally with June7. For additional info on database design and concepts
see post #2 at https://www.accessforums.net/access/...7-a-26794.html