A
Andrew C
Hi
In my client table i have a field called suburb. This field looks up the
suburb table to get its values. In the Suburb table i have a suburb field
and Post code fields.
I have based a form on a clients query, and it shows the suburb and all
information as needed. What i need to show is a postcode on the form. How
can i get it to lookup up the suburb in its own table and return the postcode
relating to that area.
If i add the suburb table to the query and add the postcode field to the
query, it stops me from updating any records. The postcode is purely for
display view only.
Thanks for your help
In my client table i have a field called suburb. This field looks up the
suburb table to get its values. In the Suburb table i have a suburb field
and Post code fields.
I have based a form on a clients query, and it shows the suburb and all
information as needed. What i need to show is a postcode on the form. How
can i get it to lookup up the suburb in its own table and return the postcode
relating to that area.
If i add the suburb table to the query and add the postcode field to the
query, it stops me from updating any records. The postcode is purely for
display view only.
Thanks for your help