Append just current record into a table

[Abbosy]

Hi there guys,

I am trying to open a form with some records taken from one table, then alter couple of data in it and after that most importantly to append current records into a different table.
The reason I need to append is that I need to keep track on every occurrence on same fields.

It looks like this:

SerialNumber(Field 1), ServiceDate(Field 2), ServiceEngineer(Field 3)


Now suppose same serial number called again and asked for service, I need to still keep record on how many times this same serial number had service. I really appreciate your help guys.


Best Regards
Abbosy

 

[pr2-eugin]

The question is why two table? Why not store them in just one?

 

[Abbosy]

Because the first table (installations) from which all the information are taken into the second one (CallOuts). The installations has a serial number set to unique but the call outs is set to can be repeated (indexed duplicates yes).
Obviously in the installations each machine has its own unique serial number, but same machine can be in call out several times if anything wrong goes with it.
Now, there are installations, as well as maintenance and also the yearly service.
I just need to have a record of all the times the engineers made a visit.
Off course this can not be saved in installations, but I don't see why not be able to save it in call outs, or indeed in a third table.
I always appreciate the help you guys provide here.

Thanks

 

[pr2-eugin]

Okay now it makes sense. You have two tables that are related with One to Many relationship. Good start. What you need is create a Form with a SubForm. The Form will be the Installation table and the SubForm will form the CallOuts table. This should get you started. IF you have any problems post back.

 

[Abbosy]

I assume this should do. Thanks very much for your help

 

[pr2-eugin]

You're welcome ! Good luck

 

[Abbosy]

:banghead:Hi guys again,

The subform worked very well, but it didn't give me what I wanted.
I linked serial numbers of the form (One) to the form (Many) and it as I wanted but its not like what I expected.
What I wanted is to let's say put the serial number in the FrmCallOuts (the one side) and for it to show how many activities there was on the same serial number in the FrmWholeHistory (the Many side). Automatically if possible without the need to repeat it again in the subform. This can be achieved in excel spreadsheet in a calculating field.

How can I achieve this please?

 

[Muna]

is your sub-form continuous?

 

[Abbosy]

Hi Muna,

Thanks very much for your reply.
This is a good question. How can I find out if it is?

Thanks

 

[Abbosy]

Hi there again guys,

When I move through the index on the CallOuts (One), i.e incrementing then it changes the serial number in table WholeHistory(Many); it shows how many serial numbers but it doesn't show rest of the fields.
I put in CallOuts all the fields there, and in the WholeHistory Just 4 fields (SerialNumber, DateInstalled, RimalInvoiceNo & RimalInvoiceDate + other fields they need to fill when finishing the job.
I need when it picks up serial number to show rest of the fields
I'm sure it is possible.

Best Regards