Recent content by MelissaMuz

Oh of course! I should have guessed that! Thank you.

This is all very helpful thank you, could you just confirm what PK and FK stand for?

That makes sense, thank you.

I'm not too sure how this would work on my db, because it is I suppose a 'project' that is the 'order', the parts are what goes into the project, i want to store what parts each project needs and track when they have been ordered and received as well as parts we already have in stock for future...

Yes, thank you. I have actually seen both of those before! They are both very helpful. Thank you!

Hello, I joined a couple of weeks ago now but thought I'd introduce myself! I'm Melissa, and I'm working on a stock database with very little knowledge of Access so I have been coming on here a lot for help. Everyone seems very happy to help so far! Thank you in advance for the advice :LOL:

I have read the Allen Browne article, yes and I understand it will be much harder this way, so I guess I will have to make some changes. I have done a very small amount! But not much at all.

I am not sure what is meant by this, but I have a form for inputting new orders if that is the question.

Thank you all, I have been toying with the idea of making a separate table for the Quantities but I hadn't needed it up until this point. I am certainly going to look into this.

Hello! I am making a stock and orders database and I need some help with calculating the totals. I have a table called Orders, as well as a Parts table (among others). I have the Quantity On Hand of each part listed in the Parts table. When we receive an order (indicated with a tick box on...

oops nevermind i fixed it.

Unfortunately I'm struggling with this! It says "you cannot add or change a record because a related record is required in table 'parts'" (the table I am trying to pull information from). But there is already a relating record in that table so I'm unsure what could be causing this.

This is great, thanks a lot for your help!

how do i do this with it being on another table?

Hi I'm completely new to Macros (and pretty new to Access in general). I was wondering if anyone could help me to set up one. I am wanting to update a field in my table automatically when I input information into another field in the same table. The information needed for these fields is stored...