Unanswered: Importing records with link to M2M field
Hi - I have a database which has three main forms;
Form 1 - contains details of motors vehicles
Form 2 - contains a record of car parts for sale
Form 3 - is a listing of car parts
Form 2 has a M2M field with Form 1 and a Simple Rational Field with Form 3. I would like to import records from Excel into Form 2, however, if i have the vehicle details on my Excel file is there any way they can be linked to the M2M field contained in the form.
My question is if I import data can it be linked to a M2M field in any way?
In order to link forms while importing, data should already exist in one of form (Form 1).
This is what I will do:
1. Import first the vehicle details in to form 1.
2. Import records on form 2 where data contain an unique field from form 1.
I have attached an example base on what I understood from your request.
Note: I'm not involving Form 3 in the example at all since I'm just showing the way of importing and create relationship with other form.