Search results

When we receive the "sugar" it comes in a box full of "sugar packets." The lotnumber of the box tells us how many grains of sugar each sugar packet has. We can receive Stevia, Splenda, Equals, etc, but they will all have several different lotnumbers to each sugar brand. When we give it to...

Sorry about that. Each factor (product name) can have different lot numbers. Each distinct lot number has a specific weight associated with it. We can receive the factor, which may be a new factor and/or a new lot number. We also dispense the factor, to a specific individual. I initially...

Good afternoon everyone, I was hoping that I could get some feedback on my relationship structure. I am unsure which one would make the most sense regarding the products. Thanks in advance.

I'll give this a look-see. Thanks. In regards to a form, would I then need 2 sub-forms within the main form to update all 3 of the tables?

Thanks for the reply Mark. I'm basically trying to keep track of how many excipients we receive and use. It may sound weird but where I'm at, the solution is already mixed with the excipient, but on the label it includes how much excipient there is. That's what I'm keeping track of. A certain...

Hey all, So I'm having some trouble figuring out how to set up my form/subform. Heck, I'm not even 100% sure that it's what I need. tblExipients - ExipientID (PK), ExipientLotNumber, ExipientAmount - Each ExipientLotNumber has a different ExipientAmount tblSolution - SolutionID (PK)...

Hey all, I was wondering if this is possible or if there is probably an easier way to do this. I have a form with 2 command buttons, depending on which button is pressed, it will open a corresponding form: RECEIVE --> frmReceive SALE --> frmSale These both feed to the same table but have...

I was wondering what these fields were for. Are you saying I should have 2 other tables for received and sales? That is what I had changed it to, but without this table. I also didn't have these as primary keys in their corresponding tables. Can you help me understand? Thanks!

For the tables, I'm going to try going back to 3 tables and trying it out in a similar fashion to how you mentioned. I'm probably thinking too far ahead. For reports or just to show on a form, I would want a running balance based on the ItemName (which includes all of the Item#s). I thought...

Correct, it's not like the gun shop scenario. In this case, the Item# will differ depending on the weight (ItemAmt) of the Product. So 1 product can have several different item#'s. An Item# can only have 1 ItemAmt associated with it. I didn't think to do that with the quantity. Now I'm thinking...

Thanks for the response Ranman. :) So then for the LotNumber combobox, would I use the tblfactors or tblorder as the source? I'm guessing the tblfactors since it is the main one.

Thanks for your response Coach. I did end up making more than 1 table. I ended up separating the dispensed from the received. I figured that it would make it easier to have forms feed into them. I also have a table for the items and another one for the customers. I've attached my...

Thanks for your reply Ranman256. The reason I have tblFactors linked to tblOrders is so that I can use data for reports of orders made (tblOrders) while using the data from tblFactors. Say I wanted to know how much (LotAmount, not Qtyout) a certain individual has received. Or who was given what...

Hey all. I've attached my table ships and a written out concept of how I plan to make my forms. This isn't my first attempt, I tried before without drawing it out and it didn't work out (Join key of table "x" not in recordset). I was wondering if someone could please let me know if I'm on the...

Thanks for the response Ranman. I will need to track each event, so it's similar to the last situation you mentioned. I'm not fully understanding you when you mentioned that the child table would track each event. Wouldn't I track the events via a Union query (for each item)? Thanks!

Hello everyone, I had a question I was hoping to get some help with. I want to make a db to keep track of items. I was unsure if it would be best to have 1 table with a field which states if an item is received or dispensed, or if I should have 2 separate tables, 1 for received and another for...

Thanks for your reply Steve. I was definitely unaware of that. That sucks. I definitely have 3 different different tables for that 1 form. I have 1 table that pulls from the other 2. I haven't done subforms before. But I'll look into those. I'm trying to make it as easy as possible for an...

Hello everyone. First time posting here. I was hoping I could get some assistance. I've put some work into this new database, but it's been a while since I've done much with access. I wanted to try out some of scripts that I'm trying for the first time on a couple of combo boxes in a form. But...