B
BC
I wish to use a form (called frmClaim) to edit and add records to a
table (tblClaim).
Three of the fields (HANAME, STATUS and COVERAGE) are 'technically'
related (not yet related in my database) to other tables contained in my
database.
For example: Another Table ( tblHousing) contains HANAME, HA#,
ADDRESS, etc.)
There are two slightly different things I which to do in frmClaim:
1) I wish to place a combo box in frmClaim to allow for choices of entry
of HANAME such that one can select only from the HANAME choices
contained in tblHousing. (One would have to first modify tblHousing
(another form) in order to choose a different HANAME.)
2) I wish to display a textbox that shows associated HA# while
scrolling the combo box through the choices of HANAME.
Should I form a relationship between the two tables (they are not yet
even keyed)?
How should I best design frmClaim?
table (tblClaim).
Three of the fields (HANAME, STATUS and COVERAGE) are 'technically'
related (not yet related in my database) to other tables contained in my
database.
For example: Another Table ( tblHousing) contains HANAME, HA#,
ADDRESS, etc.)
There are two slightly different things I which to do in frmClaim:
1) I wish to place a combo box in frmClaim to allow for choices of entry
of HANAME such that one can select only from the HANAME choices
contained in tblHousing. (One would have to first modify tblHousing
(another form) in order to choose a different HANAME.)
2) I wish to display a textbox that shows associated HA# while
scrolling the combo box through the choices of HANAME.
Should I form a relationship between the two tables (they are not yet
even keyed)?
How should I best design frmClaim?