Feel like the only one who can't get this

[stacymae]

Hello,

I tried searching these pages in hopes that someone else was having the same
problems as I was but even the new users are more advanced than me.

I am trying to create a database for a small commercial imagery site that
will allow us to track our collection progress.

TblCollection
Collection ID- Auto Number [primary key]
Date of Pass
Satellite
Start of Pass
End of Pass
Total Scenes

Here's where my problems start, I need to track the number of scenes cut to
CD from each pass but there could be anywhere from 1-100 of them so I created
another table

tblScenes cut
CD ID [primary key]
Image Type
% CC
Satisfied

Now, how do I make a form/relationship/anything that will help me enter the
data from the pass, to include multiple CD's cut and later query by date and
find out how many scenes were cut on which pass?

I have many more questions but I don't want to chase everyone away right off
the bat.

Today I tried adding the CD ID to the tblCollection and then creating a
one-to-many relationship but when I created a form and subform to enter all
the data, it didn't connect to each other.

any help would be greatly appreciated
Thanks,
Stacy

 

[Tim Ferguson]

Sorry, I've edited a bit for brevity:

Collections
( *CollectionID, DatePass, Satellite, StartPass, EndPass, TotalScenes)

If you have another table storing details of the Scenes, then the
TotalScenes is redundant, as it can easily be counted up from the Scenes
table.

Scenes
( *CD_ID, ImageType, PerCentCC, Satisfied)

If scenes belong to a Collection, then you need a foreign key pointing
to the Collections table. I don't know what PerCentCC is -- presumably
some attribute of the picture?

Now, how do I make a form/relationship/anything that will help me
enter the data from the pass, to include multiple CD's cut and later
query by date and find out how many scenes were cut on which pass?

That really depends on where and how your users get their data. Can they
extract direct from the CD (you might not need a data entry form at
all...)? Can the CD_ID values be read from barcode or from character
recognition? Is this a hand-written form (with major transcription error
worries)? Do you get all the data from one collection at a time, or you
have to keep changing from one to the other? How do they do it at
present?

One way is a form for the Collection details, and a subform for the
Scenes. The judicious use of combo boxes, and some code to manipulate
the DefaultValues of the text boxes will probably make your users' life
easier but it all depends...

Best wishes


Tim F