T
Tom Wesley
Hi all,
I'm very new to Access itself, but have used another database system
called Equinox for Windows (www.compsoft.co.uk) so know a bit about what
I'm trying to achieve.
I have a sales order processing database with just two tables, ORDER,
COMPANY, with a CompanyRef as the key in COMPANY.
I have a form for the ORDER table, but haven't found a to show fields from
the COMPANY table during data entry. For example, after entering the
CompanyRef, the address and company names would appear on screen for the
user to verify. Note that I do not want these fields to be editable, as
they reside in a different table.
Is there an easy way to do this that I have missed, or am I better
sticking with the little-known Equinox?
Also, could you please cc my email account, as I'm a little rushed here
and would appreciate reading any reply as soon as it gets posted.
Cheers in advance,
Tom
I'm very new to Access itself, but have used another database system
called Equinox for Windows (www.compsoft.co.uk) so know a bit about what
I'm trying to achieve.
I have a sales order processing database with just two tables, ORDER,
COMPANY, with a CompanyRef as the key in COMPANY.
I have a form for the ORDER table, but haven't found a to show fields from
the COMPANY table during data entry. For example, after entering the
CompanyRef, the address and company names would appear on screen for the
user to verify. Note that I do not want these fields to be editable, as
they reside in a different table.
Is there an easy way to do this that I have missed, or am I better
sticking with the little-known Equinox?
Also, could you please cc my email account, as I'm a little rushed here
and would appreciate reading any reply as soon as it gets posted.
Cheers in advance,
Tom