Fill combobox and form

A

Al

Hi there,

What I am requiring is a form which when i look up the ID
in a combobox(IssueID), matching fields for that record
will appear - I need to be able to ADD a new record so all
tables are filled...

My tables are as follows

tblOwner
OwnerID - primary key
OwnerLN - last name
OwnerFN - first name

tblArea
AreaID - primary key (can also use AreaCode)
AreaDesc - decription of area

Priority - can also use a value list in a combo box
PriorityCode - primary key

tblPart
PartCode - primary key
PartDesc - descirption of part

tblSupplier
Supplierid
SupplierName

tblPartSupplier
PartCode - foreign key to Parts Table
SupplierID - foreign key to Supplier table
Price

Primary key = PartCode + SupplierID

tblIssue
IssueID - primary key
IssueName

tblIssueOccurance
IssueID - foreign key to Issue table
IssueDate
OwnerID - foreign key to Owner
PartID - foreign key to Parts
SupplierID - foreign key to Supplier
PriorityCode (should this be on the Issue table ?)
Line Stop Time

Primary key = IssueID + IssueDate

Any ideas Guys???

Al
 
G

grep

Have you tried the wizards for finding a record based on the value of
the combo box? That sounds like what you need.

grep
 
Top