Queries & Reports

W

Windseaker

QUESTION .

First I will enter info into TBL Radio Receipt, from there I want the
information to jump to TBL Radio Info and prompt me to complete this table.
Then it will jump to either TBL New Radio Information OR TBL Repair
Information. This will need to be completed. How does this happen, I mean--
How do I create the relationships to reflect this path?

PS How do I attach a pic of my problem?
 
B

Beetle

Jeannette Cunningham already posted a response to your question back on
12/21, but perhaps you didn't see/understand it so we can try again.

Your question is a little hard to understand, so you might need to clarify a
few things so we know what you are trying to to do. Information doesn't
*jump* from one table to another, so I'm assuming that you are trying to
figure out how to relate your tables. If that's the case, it will be hard for
anyone here to tell you what to do without knowing a little more.

Post back and give some info about what tables you currently have including
the fields names in each table. It could be that your table design is bad to
begin with, in which case trying to relate them would be counterproductive.
You shouldn't need to post a picture (which you can't do here anyway). Just
post something like this;

TableName1
*********
FieldName1 (PK)
FieldName2
otherFields

TableName2
*********
FieldName1(PK)
FieldName2

etc.

Try to include which fields are primary key (PK), etc.

Or maybe I've misunderstood what you're trying to do, in which case you
still need to post back with more info.

HTH
 
J

John W. Vinson

QUESTION .

First I will enter info into TBL Radio Receipt, from there I want the
information to jump to TBL Radio Info and prompt me to complete this table.
Then it will jump to either TBL New Radio Information OR TBL Repair
Information. This will need to be completed. How does this happen, I mean--
How do I create the relationships to reflect this path?
Click to expand...

STOP.

You're making a very common error about how relationships work. You do NOT
want information to "jump" anywhere! In a relational database, you store the
information *once*, in its own table; and then use Queries to *combine* the
information in one table with related information in another table. You would
almost never need to copy data already stored in one table into another table.

Typically you will have tables in a one to many relationship, and use a Form
with a Subform to enter data into the two tables. Table datasheets are NOT
designed for data editing or data entry, and should be used only for
debugging; use Forms to work with information stored in the tables.
PS How do I attach a pic of my problem?
Click to expand...

You don't. Binary image files are not welcome on this text only newsgroup. If
you want to post a *link* to an image stored on a webserver somewhere, feel
free, but I'll only rarely visit unvouched websites or open binaries of
uncertain provenance.

John W. Vinson [MVP]
 
Top