hi
I have a table called allevents and another called tblevent
the 2 forms that I use are linked by a field called eventid
the table tblevent will have say eventid 1 but the all events could have many records linked to eventid 1
in the table called allevents there is a cost field.
how can I put a text field in my form tblevents that links to the form allevents and sums all the costs from eventsid 1
thanks
steve
I have a table called allevents and another called tblevent
the 2 forms that I use are linked by a field called eventid
the table tblevent will have say eventid 1 but the all events could have many records linked to eventid 1
in the table called allevents there is a cost field.
how can I put a text field in my form tblevents that links to the form allevents and sums all the costs from eventsid 1
thanks
steve