Search results

wouldn't this allow me to do the summary that I want with at a glance being able to see what needs to be done still meaning what orders still need to be invoiced, what orders need to be shipped out? or am I thinking about this in the wrong way

Ok I made your suggested adjustments with the exception of the OrderConf field, because that table already has a status field which I had hoped would do just what you proposed but also included a option to say that it was shipped which in my mind completes the sale. I was basically thinking...

ok give me a few minutes to absorb all that and make the adjustments thanks

I had heard that but I was told again it was really ok my concern is the ability to use in reports and such

thanks it is a work in progress!

also here is the revised relationship based on what I got from your last two posts

Well I got lost between your last 2 posts The sku is thusfar unique to each product I have new suppliers I will be working with and am planning on expanding my inventory I don't really forsee and duplicate sku's. So should the sku be the PK and the join field? I understand what you mean...

ok here is updated relationships Thanks I'll let you all know how it goes.

Ok I took care of the relationships Yes!ok now that makes sense I just wasn't seeing how I got the acutual product. Like I said I can do basic with minimal relationships and such I get lost in all the stuff floating around in my head as i'm working after the database starts growing.... Ok I'll...

LOL I took the class last semester :D

Yeah I know about the naming i just forgot oops... Yeah my payments are by customer ok I updated the tables and the relationships is this what you meant? as far as the form goes I'm getting lost at is how I or where I put in the products they ordered. do I need to add something to the...

ok great idea never thought about doing it that way!

ok i'm lost again.... I set up the tables and their relationships as shown in the attachment above. I started on the form but that is where I got lost. so I need to break this down a bit more I need to creat a subform from the table Inventory and have it like a datasheet so there is a...

Ok i have attached my relationship report for what I have so far if you see anything that is wrong or could be done differently, please let me know

ok great I made the adjustments, Most everything is still on paper at this point I'm working on the database as we speak so my next thought is I would use a query to pull the data from the Inventory table and include a where clause to block discontinued items from displaying is the correct? and...

In my access class I took the Prof said to create a table with the states in it and give each state an ID number, store the number in the fields and use a query and relationships to she the abbrevation when needed like in forms and such but when I try to make the relationships it makes a table...

oh yes I am expecting to have many more questions I took a very basic Access class last semester so I think I have a pretty good understanding of the basics of a database. Ok let me rephrase to make sure I understand your advice. I don't need both the order table and the invoice table ok...

First off I'm sort of a newbie, I mean I have made some very basic databases before but I am now in need of a more advanced database. So please be patient with me :D ok quick overview of my needs: I need a database to control my inventory and allow me to create and email invoices. My product...

good day everyone! My name is Nicolette and in new to access so i just want to say thanks ahead of time ;-)