Hi Everybody who is helping here,
Thank you, I appreciate it. I am also learning and take on board your comments.
OK, so now I would like to know how to make this label form
frmLabel1Data with a bound field as you have suggested? I am obviously going to have to make changes. Now this is where it gets hard for me as I do not want to reveal company info so I hope the example tables reflect what I am doing.
I suppose it is like building a house, get the foundations incorrect and rest is built on top of it, hhhmmmmm.....
Tables;
tblFilename 'This table is guarnteed from a scan of each CD.
fldFieldname 'This field has folder path and filename.
fldFileSize 'this filed contains the file size in bytes.
tblDBF1 'This table relates to the specifics of a project but not always on each CD with no unique ID field and can contain many records.
client
ProjectNumber
country
from
to
tblDBF2 'This table relates to the specifics of a project and is also on one of five different types of CD I need to label. Usually it has only one record.
client
ProjectNumber
country
from
to
One of the CD's have neither of the above 2 DBF's on board and this is where the user is required to make additional entry's. Even a scan of the CD gives no suggestion to client or project.
tblCDLabels 'This table is the table I was using to store the info after reading data from tables that are possibly there and then users input could change it to then update it to this table.
ClientName
ProjectNumber
TypeofMedia 'combobox with list in table only contains CD or DVD
Path1Files 'to be used to describe on certain CD's a particular path of a file
File1NameFrom 'from the above dbf's
from field
File1NameTo 'from the above dbf's
to field
I personally cannot see how this is going to be bound to a form but then again I am learning and happy for any suggestions.
Os is it just simply a matter of making it bound to
tblCDlabels or a query there from?
Robert88