Guys,
I have a database that basically logs service calls. The calls table has
entries for call no among other things. This call number field has a one to
many relationship with another table (Parts).
When filling in the details, it isn't a problem, I simply click the small
plus sign next to the call and enter parts used in the parts table, this
way, these specific parts are associated with this call.
To make life easier for myself, I have asked some of the guys to record all
of the required info on a spreadsheet and email it to me.
My question is, is it possible to have the import function split the rows in
the spreadsheet so that the required info is put into the call table and the
parts info is put into the assiciated entry in the parts table, using the
import function, or anything else that springs to mind.
Thanks