Importing data -

No problem.

Set up a scratch pad import table by creating a new table and importing your data.  It will create the fields in the first import. 

Make a Relationship to the real table where one real table entry has many scratchpad entries based on the Record ID which I assume is the Key field.

On the real table make  a formula checkbox field with a formula of

true

Look that up down to scratch pad.

Create  a saved table to table import with a filter where the lookup checkbox is checked.  ie the real entry exists  

Next create a single record in a new table called Admin Import  it will be Record  ID  #1

Make  formula URL button to delete  the entries in the scratchpad table  post back if you need help..

Make a URL formula field button to run the saved import.  Post back if you need help.

Make a url formula button to call up the import process  

i suggest that you create a Report Link field from the Admin Record to the scratchpad table so you can have an embedded report if the scratch pad entries on the admin import Record. Or create a relationship so you can count the number of scratchpad entries  

So the typical process will be to click to clear the scratchpad, then click to invoke the import tool, then click to run the saved table to table copy.

So a bit of setup, but then the import routine will be stupid should mole

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------