2 questions - Import, select data and indeterminate relationship

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have written code that imports data from another program. The plan is to
import that data into some temporary table, have some method (boss prefers
radio button) to select information that is not needed and delete it and then
send what's left to a form (subform). Any ideas on the best way to accomplish
this?
Also, what causes indeterminate relationships and how do you correct this?
I've tried and tried and can't fix this. Needs to be one-to-many. Thanks!
 
Regarding your plan for a temporary table, create a temporary external
database and then create the temporary table in this database. Using a
temporary table in your primary database will make the file bloat very
quickly. Add a Yes/No field named "DeleteThis Record" to your recordset
after you import the data. Use a form to display the records in the
temporary table and check the records you want to delete. Explain to your
boss that a Yes/No field uses a checkbox. Use a Delete query where the
criteria for "DeleteThisRecord" is true to delete the unwanted records. Do
you want to permanently save the remaining records? If yes, don't send to a
form but use an append query to add to a table. You can then use a form to
display the data.
 
Thanks for your help!

PC Datasheet said:
Regarding your plan for a temporary table, create a temporary external
database and then create the temporary table in this database. Using a
temporary table in your primary database will make the file bloat very
quickly. Add a Yes/No field named "DeleteThis Record" to your recordset
after you import the data. Use a form to display the records in the
temporary table and check the records you want to delete. Explain to your
boss that a Yes/No field uses a checkbox. Use a Delete query where the
criteria for "DeleteThisRecord" is true to delete the unwanted records. Do
you want to permanently save the remaining records? If yes, don't send to a
form but use an append query to add to a table. You can then use a form to
display the data.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com
Click to expand...
 
Back
Top