Newbie question

[webby]

Hi there guys n girls,



new to access over the last few weeks and finally discovering how great a piece of kit it is. building some good tables, queries etc for home projects to gain experience for work use.

Have one question that i cannot seem to find an answer for....(hope it makes sense)

part of my job involves creating a "claims management form" to keep a record of claims that come in.

one field that is important is a policy number which we would manually enter onto the form. At present, we would have to manually enter address and contact details of the claimant onto the claims form by switching back and forth to the policy holder table

However, if on the "claims management form) i add a field for "record number" (relating of course to the relevant "record line" in the policy holder table), can i add "address fields" from the "policy holder" table which can be " auto filled" by collecting data from the relevant record line?

thanks

webby

[NoellaG]

Hi,

you could try making a form based on the policy holders table with a subform in it stating all policies of that holder.

If you don't want a form/subform structure, place a combobox on the policies form with the holder ID. The other columns of the rowsource data of the combobox can be displayed in calculated text fields as

= cboMyCombo.column(n)

greetings
NG

[webby]

Hi,

you could try making a form based on the policy holders table with a subform in it stating all policies of that holder.

If you don't want a form/subform structure, place a combobox on the policies form with the holder ID. The other columns of the rowsource data of the combobox can be displayed in calculated text fields as

= cboMyCombo.column(n)

greetings
NG

Hi NG, I will be honest and say that has confused me a tad as not used subforms or combo boxes yet. However, I shall look into them and (like most things i learn), I will have a play with them and see what i come up with...

based on your calculation formula above, i have another question though, can you use formulas in fields to (for example) get data from certain fields/columns?

if for example i put "23" in a box listed as "ID" can you write a formula that would find data in "line 23" within a table and then go across to "column 6" and then insert the data from "line23, column 6" into the field i need to complete ...? muchos gracias

[NoellaG]

Hi,

I'm afraid you're still taking an excell based look upon a database. Data should only be in 1 place and never copied to another "place" in the database. Maybe you should take some time first to make yourself familiar with the normalization rules before continuing.

greetings
NG

[webby]

Hi,

I'm afraid you're still taking an excell based look upon a database. Data should only be in 1 place and never copied to another "place" in the database. Maybe you should take some time first to make yourself familiar with the normalization rules before continuing.

greetings
NG

OK. makes sense, but what I am trying to achieve is that when a claim is "lodged", we enter data into a form which can be printed off and passed round the office to people who will not have access to database, but mzay need the customers contact details. so autofill would be a handy action rather than have to manually enter data.

Will take a peek for normalization rules....

Thanks
Greg

[webby]

Aha !... just realised what i should be doing ... Thanks NG, your responses have prompted me into realising what i should have done...

I need to add "all possibly needed fields" to one table and then create various forms using different fields from the one major table.

It all seems a tad easier now thats cleared a few other issues too...

Thank you
Webby

[NoellaG]

Hi,

printing reports or exporting to excell can be done through queries that combine data from several tables, so you never ever have to "copy" data.

grts
NG