QUERY BASED FORM

[696796]

Hi there,

what i need is a form which can manipulate data in a few tables. Do i need to base this form on a query and if so how does it all work?

Ideally i also want a form to look up records by using a combobox to search issue Id's and then all the related records appear, is there a way to do this - or more helpfully, in an editable form, be able to use combo boxes on the data entry form to the user to be able to select relevent input

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 ?)

Primary key = IssueID + IssueDate

Any help would be legendary,

cheers,

Alex