Is my forms concept correct?

[Chillendw]

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 right path or if I'm missing something.

Thanks in advance.

 

[Ranman256]

I don't think tblFactors needs to be in the relation with the patient.
If tblFactors is a lookup table to feed tblOrders,you don't need the join.
Patient is a parent of orders, but orders is not a child of Factors.
Factors only supplies items for orders. I would remove this join.
(If I understand it)

Like a client lives in a country. The country codes feed this field,but is not in the relation. Country table only supplies the codes available. Deleting the patient also removes his country code, but it does not affect the tblCountry table.

 

[Chillendw]

I don't think tblFactors needs to be in the relation with the patient.
If tblFactors is a lookup table to feed tblOrders,you don't need the join.
Patient is a parent of orders, but orders is not a child of Factors.
Factors only supplies items for orders. I would remove this join.
(If I understand it)

Like a client lives in a country. The country codes feed this field,but is not in the relation. Country table only supplies the codes available. Deleting the patient also removes his country code, but it does not affect the tblCountry table.

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 (including FactorName) on a certain day. I figured that if I didn't have the join, it would fill the spot, but I couldn't attach other information (such as the LotAmount) in a report later on.

It could be that my notion of joining is incorrect tho.
"Say I wanted to know how much (LotAmount, not Qtyout) a certain individual has received." -- I suppose that I could make a query, but if my LotsNumber field isn't joined, how will it know which LotAmount to pick?

Please let me know if I'm thinking about this the wrong way.

Thanks again.

 

[Ranman256]

you can still join Order to Factors in queries, but doesnt need to be in a relation.

 

[Chillendw]

you can still join Order to Factors in queries, but doesnt need to be in a relation.

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.