Relationships...

[FLAME-oN!]

So i have table 1 and table 2 - initially we fill in table 1 with Name, Address, Ref No and Date of contact - we then await return of a form we send out then fill in table 2

can i make it so on completion of table 1 it automatically completes the same information thats required on table 2 (name, ref no and date of contact)

THEN! when you complete the form for table 2 when you enter the key data (ref no) can you make it so the information from table 1 (name, date of contact) pops up automatically?

thanks in advance ''

 

[Mile-O]

Why not just use the information from the same table for the differing forms?

 

[FLAME-oN!]

good plan...

is it possible to make it so on entering the key data (ref no) on the 2nd form the required information from the first form is entered on the 2nd form?

 

[Mile-O]

Take a few steps back.

If you are going to be building a database then rest assured you can do nearly anything you want with it...

...BUT...

...in order for your database to work properly and without error going forward you are going to have to take the time to think about your data structures: what sort of data are you taking in and what are you wanting out?

It sounds as if you haven't thought about your tables so this might be a good point to receive advice.

Outline what tables you have and highlight any relationships you see.

 

[FLAME-oN!]

i have planned it all out but im more a 'it looks like this' thinker and i am just learning how to use Access - i know exactly what i want i want it to do (i even made a powerpoint presentation to show the bosses) i just dont know how to do it! i got this book but its no real help! i just says 'use the wizard' mostly haha

 

[Mile-O]

So, what does it look like?

 

[Rich]

Access comes with a contact management db, it's a good place to start

 

[FLAME-oN!]

right heres how i want it to work -

clmt calls us requesting a claim - grunt opens 'claim request' form and takes ref no, name, address and puts the date on (date of contact)

- using the mailmerg with word tool it then prints out a letter and the grunt sends this with a claim form (i need it work work out 1 month from the date of contact and put it on the letter)

then when we recieve the claim back the grunt opens the 'claim management' form - enters the nino - the name and date of contact then come up in specified fields, they then enter further information but we will get to that later

 

[Mile-O]

enters the nino

The nino?

in specified fields, they then enter further information

Wouldn't it be better to detail these "specified fields"?

What sort of further information are we talking about? Claim history?

 

[FLAME-oN!]

Sorry, Nino = Ref number

further information = more information i need to store - but for know i just need to know about getting form 2 to show information recorded on form 1 when the ref number is entered

if you want i can email you the slide show i made to give you a better idea? whats your addy

p.s. when talking about specified fields i just mean they will appear as per the layout of the form so that the grunt knows they entered the correct ref no - obviously if there is no trace of the nino it will say so