Hi,
I'm pretty new too Access 2000 and I have a database that I with the
details of peoples names, i.e. surname, forename, ref number. I have
another table with surname, forename, etc plus some other details,
including videos. For arguments sake, the first person is a parent,
the second is the child, and the videos belong to the child. The
problem that I am having is that on the form I can manage to get the
details of the parent on it with a subform of the child details but
when I add the details of the child via the subform and click add
record, the details aren't saved. I'm sure that I am missing something
really obvious here. There are also a few other things that I would
like to be able to do to the form. I would like to be able to link
each child to a video/s and then record the movement of that video to
various parties as well as give the video a unique reference number.
So the child may have 4 videos all the same, but each video has a
number that refers to the autonumber generated for the parent as well
as its own unique number, i.e. 37 – 2 (being video 2 of 3, and parent
37).
As well as all this I would ideally like to be able to add videos at a
later date, record their movement during the course of them being
tracked and provide a link to a standardised Word document, ideally
self filling (i.e. with Parents details, child details and amount of
videos received relating to the details on the screen).
I've got stuck at designing the form for the videos as I'm unsure of
how to link them all up. Any help would be appreciated, I am new to
Access so I don't know VBA or the majority of the
programming………… .nightmare.
Many thanks,
Armitageshanks