Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2012
    Posts
    23

    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?


    Thanks
    Paul

  2. #2
    Join Date
    Apr 2013
    Location
    USA
    Posts
    132
    Provided Answers: 2

    Possible solution

    Hi Paul,

    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.

    MyDBApp.zip

    Hope this work for you.

  3. #3
    Join Date
    Apr 2013
    Location
    USA
    Posts
    132
    Provided Answers: 2

    csv file

    Here is the csv file that I used for previous example.

    parts to impot.zip

  4. #4
    Join Date
    Nov 2012
    Posts
    23
    Thanks, but I can't open the database file keeps coming up with invalid header error.

    I'm still using v9.4, are you using a higher version?

    Thanks

  5. #5
    Join Date
    Apr 2013
    Location
    USA
    Posts
    132
    Provided Answers: 2
    I'm using v10.5. Please go to Brilliant Database website and download trial version so you can open the attached file.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •