View Single Post
  #35  
Old May 30th, 2007, 04:39 AM posted to microsoft.public.access.gettingstarted
JackShephard
external usenet poster
 
Posts: 21
Default ACCESS DVD Database

On Tue, 29 May 2007 02:30:14 -0700, JackShephard
wrote:


I am starting to get you guys' lingo down a bit too.


I have a question.

I have an already populated "Purchasing table, imported from my
spreadsheet. It has about forty records, and uses the DVD_ID as a key.

I want to add those fields to my new "DVD_Main table, and then import
those records to the appropriate DVD_ID records in the main table. Is
this a quick, dialog based job, or do I have to jump through a few hoops
to pump the data in?

Also, I had some relationships made, then deleted them, but my main
table still has little plus symbols in front of the record that drops
down this purchasing table. I thought that deleting the relationships
would get rid of that, but it has not.

After I make the fields, and import the data, I can delete the table,
and that should kill it, no? Or is that plus merely showing additional,
off screen fields when I drop it down?