G
Guest
Have a database supporting thousands of kids and every 6 months need to add
their latest photo to a record.
Have 2 tables.
Table 1 (Child) - stores name,DOB, etc. No change.
Table 2 (Child Health) - stores child weight, height, and other data, as
well as OLE (at the moment). This table is linked to Table 1 as 'many to
one', as new records need to be written on each child every 6 months.
Issue - database will get 'heavy' after a while.
How can I link the Field for photos to a Folder in the computer's memory?
Also what is the best folder set up for photo storage to do this?
their latest photo to a record.
Have 2 tables.
Table 1 (Child) - stores name,DOB, etc. No change.
Table 2 (Child Health) - stores child weight, height, and other data, as
well as OLE (at the moment). This table is linked to Table 1 as 'many to
one', as new records need to be written on each child every 6 months.
Issue - database will get 'heavy' after a while.
How can I link the Field for photos to a Folder in the computer's memory?
Also what is the best folder set up for photo storage to do this?