Tables and their relationships
Tables and their relationships
(OP)
I am designing a system which is based on a schema, but i don't know how to link reference tables to validate if the user has entered valid data or complete rubbish.
E.g
tbl_order
Order_id (PK)
Advice_no
Supplier_id
Dept_no
Destination_no
No_of_singles
Unique_ref_no
Reference table
tbl_Supplier
Supplier_id (PK)
Supplier_desc
How do i validate wether the user has entered a valid supplier number?
Can anyone help?
E.g
tbl_order
Order_id (PK)
Advice_no
Supplier_id
Dept_no
Destination_no
No_of_singles
Unique_ref_no
Reference table
tbl_Supplier
Supplier_id (PK)
Supplier_desc
How do i validate wether the user has entered a valid supplier number?
Can anyone help?
RE: Tables and their relationships
one to many from tbl_Supplier to tbl_order
RE: Tables and their relationships
RE: Tables and their relationships
Display Control: Combo Box
Row Source Type: Table/Query
Row Source: SELECT tbl_Supplier.Supplier_id, tbl_Supplier.Supplier_desc FROM tbl_Supplier ORDER BY tbl_Supplier.Supplier_desc;
Bound Column: 1
Column Count: 2
Column Heads: No
Column Widths: 0"
List Rows: 8
List Width: Auto
Limit To List: Yes
RE: Tables and their relationships
Also yes you can put all kinds of add'l data into your supplier table such as Supplier Name, Phone, Contact Name, Fax, Adress, Supplier Type, etc. For instance if you had 25 diferent supplier types, you could have a Supplier Type lookup table related to that field too.
RE: Tables and their relationships
Also..
I prefer 0" as the column width rather than 0",1", if you have only two columns in the combo and are hiding one. That way, if you have your list width at Auto, then resize your combo-box, your column will grow or shrink appropriately.
RE: Tables and their relationships
RE: Tables and their relationships