Hiding controls and images when data is blank. Access 2007

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

Hello All,

I am creating a product manifest (Bill of Lading/Shipping Summary) for my
company. For each of these manifests we use multiple venders of the same
product to fill an order. So, on the manifest we need to specify which
vender the product came from and what sizes were used to fill the order. I
am not sure if I should create another table to store this information how
this information and if so how would link multiple records to one
MANIFEST_ID(Primary Key) on my main DB table. I also use some lines to
visually separate the values, I need to hide these lines when the values are
blank.

Hope you can help.

Thanks

Richard
 
You may need to show is the fields for your manifest table cause I'm not
following the "we use multiple venders of the same product to fill an order.
So, on the manifest we need to specify which vender the product came from and
what sizes were used to fill the order." portion of your statement. If you
simply list a product with a Vendor and Size on the product line, you can use
a combo box to select your options. If you have more than 4, then build a
lookup table and use the wizard when you add the combo box to use the table
for your combo source. If you have a product with multiple vendors and sizes
for each product, then you need to build at least one relational table
linking your mainifest_ID key to a mainfiest foreign key in the related
table. Add more details if you need clarification.
 
Below are the fields from my table, hopefully this help you understand what I
am trying to do.

MANIFEST_ID
CUSTOMER_NAME
TIME_STAMP
PO_NO
ORDER_DATE
PICKUP_DATE
PICKUP_NO
PICKUP_LOC
PICKUP_LOC_DETAIL
REFRENCE
COMMENTS


**On some orders we use multiple LOTS to fill orders**
--------------------------------
LOT_NO1
AWB_NO1
SML_QTY1
STD_QTY1
LRG_QTY1
XL_QTY1
JBO_QTY1
TOTAL_QTY1

EXT.. Up to LOT_NO8
 
If you want a main manifest form linked to a subform listing the Lot info,
put a foreign key in tblLot like fkManID and link it to the Man_ID field.
This way you can insert many Lots for each manifest.

You may need to build it as a many:many structure if the lot numbers are a
fixed item, ie, Lot 1 always has the same AWB, Sm_Qty, Lg_Qty... so you end
up with a manifest form and a subform that you select a specific Lot.
Someone else may have a better solution for you, I'm still not grasping the
exact concept.

Manifest table OK

tblJct
JctID
Man_ID
Lot_ID

tblLot
Lot_ID
AWB_No...
 
Back
Top