Search results

Hey. I know it's so complicated. Haha. So the Supplies Request is tied to the Donor. But it is also tied to the Employee and Department. -_-

It's so complicated. :( Can I not calculate on hand stocks using a query or report? :(

I will read the link you said. :) As for your questions, 1. The employees/requester are the ones who acknowledged the receipt of goods everytime they ask for a certain item from me. 2. The t_DSPN is for Donor Information and so I could have a source for the donor code (DSPN) to link it to...

Oh I'm sorry. I didn't want to sound demanding or anything. :) Anyway, I do have another question though. I want to see my inventory levels real time. Would it be wise to do a calculated field on a table? If not, how then should I do it?

Hey Gina, any updates? :)

No problem! :) I'm actually making a new data model just so I have more options.

First question: Isn't the Acknowledgement Form for when the Department receives the items? If so, that needs to be attached to the Purchase Order. Yes, but no. For better visualization, I will divide items to three categories. 1. Office Supplies (Consumables) All consumable supplies are...

Oh yeah. I see your point. The answer to your question is no. There could be more than one Purchase Order per Supplies Request. And there could be more than one Receiving Report per Purchase Order. :)

1. Get Request Form (Supplies Reqeust) 2. Fill out Purchase Order 3. Receive items (Receiving Report) 4. Acknowledge Receipt (In-stock item requisition) Yep, I guess that's it. There are more steps I should add but I'm focusing on this for now. Those could follow later on. It's really kind of a...

Haha. Yeah. I would really appreciate it if you could give me feedback about this. :) Thank you in advance. :D

Here's a copy of the database. :)

I'm back! The image above shows my progress. But I've only just made tables. I intend to create queries that I ought to include in my relationships model but they could follow later. I wanted to show my model first, plus I'm also stuck. PS: As property custodian, I am in-charge only of...

That's overwhelming. :( Thank you. I'll study your model first and I'll rethink my database. Thank you! :D

Gina, Let's just say I'm doing something like this in Access: http://indzara.blogspot.com/2013/07/InventorySalesManager.html A sort of point-of-sale system, but applied in a different way. I've already been able to do something like this in Excel, but for confidentiality reasons, I've just...

Okay okay. I'll work on the tables. :3 Will update soon. :banghead:

Gina, I know I'm being really annoying right now. But I want to just settle with having different fields for my strings. Yes, I'd have an [ID] Field which is autonumbered. I'd have an [Item] Field Then I want to have a different field for [ItemCode] which will add the first letter of the...

How's that gonna look like?

I know what you mean. I've been reading and watching tutorials on the internet and have made a sort of framework on how I want my database look like. I really just thought that I could generate an automatic ItemCode (prefix+autonumber) as I go along setting up my Items Table. Thanks a lot for...

I guess I'm going to have to make a different table for a list of employees and departments. What I've shown you is just a table of all the items that I have on stock, and a form to input or edit new or existing items. I just really want to have an automatic ItemCode. When you said that I have...

Here's a copy of my very simple database. I didn't want to edit the layout/style yet.