Quey in a subform (and other problems!)

M

Mattymoo

Hi

I'm trying to build a database to manage the following:
Client details
Claim details (one to many relationship with client)
Pending details (one to many relationship with claims)

I have set up a query to pull a field (adviser name) from the claim details
table as it is this field that I need to view when inputting pending details.

I've set up a form for the input of the data - It's on tabs with the three
categories above. The client and claim detail tabs are fine, but I'm
struggling with the pending tab where I've used a sub form based on the query
above. It needs to be a continuous form so I can see and update the various
pending reasons and follow up dates for each claim, but I think I've done
something fundamentally wrong as I can't update or add records.

Have I done the right thing by using a query for the subform - I couldn't
seem to find another way of including the adviser name with the pending info.

Any help appreciated as I've got in a bit of a muddle - I can provide more
info if required

Thanks

Pauline
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top