Multiple tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have one main table showing contact status and loads of details and i have
created a button to link many address to this record but in a seperate table
(table2) this is all done via a linked customer id record .
i have now been asked to display one type of contact on the main form that
relates to the customer id on screen i already have a query to seperate
Customer from prospect running on the form but i cannot get any data to be
displayed from table 2 onto main form without using a subform since i only
want one record and not all please can some help 2:30am and my brainnis fried
 
< chuckle > "2:30am and my brainnis fried"

I hear you.

But unfortunately, your post does not really tell us much about your form's
specifics re: design, tables, queries, etc. for us to give some suggestions.
Can you post more details?

--

Ken Snell
<MS ACCESS MVP>

douginf said:
I have one main table showing contact status and loads of details and i have
created a button to link many address to this record but in a seperate table
(table2) this is all done via a linked customer id record .
i have now been asked to display one type of contact on the main form that
relates to the customer id on screen i already have a query to seperate
Customer from prospect running on the form but i cannot get any data to be
displayed from table 2 onto main form without using a subform since i only
want one record and not all please can some help 2:30am and my brainnis
Click to expand...
fried
 
ok no probs

main table contians sales information contact status and license fee prices
etc with primary key of customer id. table two contains address linked via
customer id.

table two usually has 4-5 address records that are linked by customer id.
these are held seperatly and have an identifier like main sales or head of it


i currently run a query that filters the records on the main from so that
only customers are show or prospects.

what i need to do show on the main form is the main sales contact for this
record.
 
Thanks for responding so quick the answer is yes

currently i have two queries runnning to break up the database in to
customer and prospects and displaying the relevant data since i have now
added in table two that has multiple contacts against each customer/prospect
when i try to add in and subform it list all the contacts against the record
and i only want it to show a single record that has a particular marker. now
i have setup a query to sort this problem out but i cannot add the field in
the form since it is not part of the original table.

if i change the source data to be a qrycustomer and not a table i won't get
the data displayed from the other qryprospect when i use the
prospect/customer button to switch between the record types. I think?
 
I admit that I'm still confused... your form is displaying either customer
info or prospect info, but not both? And you want to show a single value
from one record from one table?

Perhaps the DLookup function can be used as an expression in a textbox in
order to show the desired value? Check it out in Help files and then post
back with more info/questions.
 
soory my brain really was having a few issues i have now resolved this by
enhancing my query to include another query and set the join to be all
records and matched records.

sorry to i think in the process of doing this i confused myself a good night
sleep seemed to sort me out.

Thanks for your help and yes when i read it back i was also confused about
why i was trying to do it that way all i need to do now is add some if
staements and i am home free.

again thanks for your input!!
 
Back
Top