Search results

Hi! This is what I currently have. I got rid of the queries and added the Acknowledgement table. :) I have another concern though. So in the database that I am making, items could be anything from office supplies to wood/lumber. However, some items like cabinets, cellphones, etc. need to have...

Okay then. I won't worry about those for now. I just need to settle my tables first. I'm really sorry. It kinda seems like you're doing all the work. But I really want to make it and learn at the same time. It just takes a whole lot of time because I'm new to this. Sorry. :banghead:

To answer your questions/concerns, one by one... Do you have a list of rules for the business, or a narrative that describes all of the business you are trying to support with this database? Please see previous post. :) In t_Employee I'm not following the need for Lastname, FirstName...

General Conditions I am trying to track inventory levels and the flow of procurement and receiving of items. The organization has several sources of funds called "DSPN". Each source of fund could be given to more than one department. There are also different departments in the organization. A...

Wew this is gonna be a long one to process. Okay, I will explain it, and will answer your questions in my next posts. :)

1. Okay. So I reviewed the recent model you made. And I see that you have deleted a few relationships. I understand why and how. But my question is, what do I do with those fields that still need lookups? Don't they also need relationships? Here is the relationships that I am talking about...

Ah I see. :) Okay that's clear. Thanks!

Haha. Sorry. It's like you're talking to a child. -_- I will review it then. :)

By the way, I'm not sure if you've answered my question about the RR. "I cannot understand how I would be able to make checkboxes relate to the Receiving Report. You said that there is only one checkbox for the PO and the RR right? But if I check that, it doesn't necessarily mean that an RR has...

Okay sorry. :) When you said, "you can't drop tables in queries that are unrelated," what did you mean by drop? -_- Anyway, will study it. I'll let you know if I have further questions.

Yes. But those are the old ones. I'm still trying to re-do everything and I'm not quite finished yet. I'm still trying to make the model. I know that it's a bit messy. But just to let you have an idea of where I am currently, here's my progress. It's still not complete as I have to still...

1. DONE 2. Actually, I did. I mean, I related it but just named it different because that's how I want the table to look like. Is that okay? Or should I just change it to SupplierID? And another thing, I know it should be related to SupplierID but in the lookup, what should show is just the...

Already have. It's not exactly what I'm looking for. :(

I'm not sure if the title is very appropriate or direct to the point. But here's what I'm working on. In our organization, when employees need to ask for office supplies, they have to fill out a Supplies Request Form (SR). Then Procurement team makes a Purchase Order Form (PO) based on the SR...

So, this is where I'm at. I'm really stuck with SR-PO-RR relationships. I don't know how they should be connected. And it's so hard to explain.

No, not finished yet. I'm redoing everything, keeping in mind the new model that you have made. However, I'm stuck at SR-PO-RR. Because I really don't know if I should make tables for each of them. I can't imagine how it would look like. :( I'm not sure if I'm able to explain this right. So in...

In the Northwind Traders template, the form has the checkbox "Post to Inventory" which is dependent two other tables, and two other forms: 1. OkAlert form 2. YesNoAlert form And I'm not sure about this but I think the checkbox triggers a Macro. But I don't want it to be too complicated and i...

Hmm. I haven't really made any queries yet. Because I didn't know how to relate them to the forms when it comes to checkboxes. So are you saying that the checkboxes will be in a query and not a form? And that I have to make queries for all the three forms (SR, PO, RR)? :)

Hey Gina, So I basically have three major forms: Supplies Request, Purchase Order, and Receiving Report. In my previous model, I made three different tables plus one table each for their details. That would result to redundancy of information since the items that are in PO are the same items...

WOW. This looks so much tidier than the model I made. -_- I feel so embarrassed. Haha. I'll study it first then maybe I'll make a few changes depending on how I understand it. I'll update as soon as I can process all the info. It's hard to digest. Haha. :banghead: