Record Dependency

Hi Raven,

Regarding Frerquency, add another table to my original recommendation:
TblFrequency
FrequencyID
Frequency 'monthly, daily, etc.

Then add another field to TblReport:
FrequencyID

Add this relationship:
FrequencyID in TblFrequency === FrequencyID in TblReport

Create your relationships in the Relationships window. When creating
relationships, add the appropriate tables to the relationship window then
drag the primary key and drop it on the foreign. For example, n the above
relationship, TblFrequency and TblReport need to be in the relationship
window then drag FrequencyID in TblFrequency and drop it on FrequencyID in
TblReport. Look in the Help file for Referential Integrity and Cascade
Update and Cascade Delete to see what they are all about. (Hint: You want
Referential Integrity for all your relationships but no Cascade Delete.
Cascade Update is optional.)

Regarding autofilling, that is done by basing your form on an appropriate
query and has nothing to do with relationshipd other than relationships
determine which tables you are able to join in a query.

By The Way, what do you think of the likes of John Marshall? He has no help
to offer you but merely shows a malicious personnal attack upon me. Do you
think that is appropriate conduct for an MVP?

Steve


"Raven" wrote in message
...
Thanks for the assistance, Steve.

The Frequency field is used to determine how often the report is run. ie,
monthly, daily, etc.

I was able to create the ids as you specified and entered them on the
respective tables. However, would I just create the link on the
relationship
tab or should I use the join or enforce referential integrity? Because,
when
I start creating the form, I would will use combo boxes to autofill or
sync
to other related fields. For instance, when the "customer" name is
entered
or selected, the "location" field is automatically filled. So, I just
want
to make sure that I am linking the tables correctly in order to make this
process work, effectively. Hope that makes sense.

--
Thanks, for spreading the knowledge.
Raven


"Steve" wrote:


TblLocation
LocationID
Location Fields

TblCustomer
CustomerID
Customer Contact Fields
LocationID

TblProcessor
ProcessorID
Fields That Identify A Processor (Employee??)

TblCategory
CategoryID
Category

TblReportType
ReportTypeID
ReportType

TblReport
ReportID
ReportDate
CustomerID
CategoryID
ReportTypeID
ProcessorID

.......... Don't know what frequency is ...........

Create the following relationships:
LocationID in TblLocation === LocationID in TblCustomer
CustomerID in TblCustomer === CustomerID in TblReport
CategoryID in TblCategory === CategoryID in TblReport
ReportTypeID in TblReportType === ReportTypeID in TblReport
ProcessorID in TblProcessor === ProcessorID in TblReport

Steve



"Raven" wrote in message
...
Sorry, I thought the additional information went through.
I would like to keep a track of all the report requests that's
processed
through our reporting dept.
I have created an inventory table that will be used to store the data
that
I
input on the inventory form.
On the table I have the following fields:
Report ID; Report Type; Category/Description; Customer/ID/Location;
Frequency/Date; and Processor
I have created child tables based on these fields with autonumbered
ids.
This is where I get confused... I'm not sure how to create the
relationship
of these tables based on the ids from each table. Hope that makes
sense.

Thanks, for spreading the knowledge.
Raven


"John W. Vinson/MVP" wrote:

On Thu, 24 Jul 2008 15:46:10 -0700, Raven
wrote:

I am creating a db for our reporting area. The db will store
information,
such as the type of reports, frequency, processed by, etc. I am
having
trouble however, setting the relationship of the tables. In addition,
when I
create the form to enter the data, the table I created does not
update,
properly with the info. Can anyone help with this issue?

Not without knowing more about the problem, no. You can see your
database; we cannot. What are the tables? HOw are they related? What
is the Recordsource of the form?

--

John W. Vinson/MVP

"Steve" wrote in message
m...

He has no help to offer you but merely shows a malicious personnal attack
upon me.

Interesting term for the truth, are you denying all the claims that are
mentioned at http://home.tiscali.nl/arracom/steveup.html

Do you think that is appropriate conduct for an MVP?

The MVPs are known for helping users of Microsoft products. Keeping users
from being scammed IS appropriate conduct.

Remember, if steve was any good, he would have enough repeat business that
he would not need to troll the newsgroups for work.


Steve

OK. I found that the previous setup information I was previously supplied
with did not work. Can someone please help me set up my tables, so that I can
affectively create my forms. When I added all the IDs to my main table I did
not know what to do with them on the forms.
I am starting from scratch.
--
Thanks, for spreading the knowledge.
Raven


"John... Visio MVP" wrote:

"Steve" wrote in message
m...

......... Don't know what frequency is ...........

Steve

Showing off the quality of your work? I thought at one time you pretended to
be an engineer? Any first year student would understand frequency and would
know that the OP was talking about how often a report is produced.

These newsgroups are provided by Microsoft for FREE peer to peer support.
Your type of help is not needed.

John... Visio MVP

Steve,
I am new to this forum. I appreciate your assistance and anyone else who
provides help. I am not here to judge anyone, but to just get the help and
knowledge I need to complete my database. I do not want to be a part of
anything else other than that.

--
Thanks, for spreading the knowledge.
Raven


"Steve" wrote:

Hi Raven,

Regarding Frerquency, add another table to my original recommendation:
TblFrequency
FrequencyID
Frequency 'monthly, daily, etc.

Then add another field to TblReport:
FrequencyID

Add this relationship:
FrequencyID in TblFrequency === FrequencyID in TblReport

Create your relationships in the Relationships window. When creating
relationships, add the appropriate tables to the relationship window then
drag the primary key and drop it on the foreign. For example, n the above
relationship, TblFrequency and TblReport need to be in the relationship
window then drag FrequencyID in TblFrequency and drop it on FrequencyID in
TblReport. Look in the Help file for Referential Integrity and Cascade
Update and Cascade Delete to see what they are all about. (Hint: You want
Referential Integrity for all your relationships but no Cascade Delete.
Cascade Update is optional.)

Regarding autofilling, that is done by basing your form on an appropriate
query and has nothing to do with relationshipd other than relationships
determine which tables you are able to join in a query.

By The Way, what do you think of the likes of John Marshall? He has no help
to offer you but merely shows a malicious personnal attack upon me. Do you
think that is appropriate conduct for an MVP?

Steve


"Raven" wrote in message
...
Thanks for the assistance, Steve.

The Frequency field is used to determine how often the report is run. ie,
monthly, daily, etc.

I was able to create the ids as you specified and entered them on the
respective tables. However, would I just create the link on the
relationship
tab or should I use the join or enforce referential integrity? Because,
when
I start creating the form, I would will use combo boxes to autofill or
sync
to other related fields. For instance, when the "customer" name is
entered
or selected, the "location" field is automatically filled. So, I just
want
to make sure that I am linking the tables correctly in order to make this
process work, effectively. Hope that makes sense.

--
Thanks, for spreading the knowledge.
Raven


"Steve" wrote:


TblLocation
LocationID
Location Fields

TblCustomer
CustomerID
Customer Contact Fields
LocationID

TblProcessor
ProcessorID
Fields That Identify A Processor (Employee??)

TblCategory
CategoryID
Category

TblReportType
ReportTypeID
ReportType

TblReport
ReportID
ReportDate
CustomerID
CategoryID
ReportTypeID
ProcessorID

.......... Don't know what frequency is ...........

Create the following relationships:
LocationID in TblLocation === LocationID in TblCustomer
CustomerID in TblCustomer === CustomerID in TblReport
CategoryID in TblCategory === CategoryID in TblReport
ReportTypeID in TblReportType === ReportTypeID in TblReport
ProcessorID in TblProcessor === ProcessorID in TblReport

Steve



"Raven" wrote in message
...
Sorry, I thought the additional information went through.
I would like to keep a track of all the report requests that's
processed
through our reporting dept.
I have created an inventory table that will be used to store the data
that
I
input on the inventory form.
On the table I have the following fields:
Report ID; Report Type; Category/Description; Customer/ID/Location;
Frequency/Date; and Processor
I have created child tables based on these fields with autonumbered
ids.
This is where I get confused... I'm not sure how to create the
relationship
of these tables based on the ids from each table. Hope that makes
sense.

Thanks, for spreading the knowledge.
Raven


"John W. Vinson/MVP" wrote:

On Thu, 24 Jul 2008 15:46:10 -0700, Raven
wrote:

I am creating a db for our reporting area. The db will store
information,
such as the type of reports, frequency, processed by, etc. I am
having
trouble however, setting the relationship of the tables. In addition,
when I
create the form to enter the data, the table I created does not
update,
properly with the info. Can anyone help with this issue?

Not without knowing more about the problem, no. You can see your
database; we cannot. What are the tables? HOw are they related? What
is the Recordsource of the form?

--

John W. Vinson/MVP

Raven,

Are you saying that you were not able to implement the tables I gave you?

Steve


"Raven" wrote in message
...
OK. I found that the previous setup information I was previously supplied
with did not work. Can someone please help me set up my tables, so that I
can
affectively create my forms. When I added all the IDs to my main table I
did
not know what to do with them on the forms.
I am starting from scratch.
--
Thanks, for spreading the knowledge.
Raven


"John... Visio MVP" wrote:

"Steve" wrote in message
m...

......... Don't know what frequency is ...........

Steve

Showing off the quality of your work? I thought at one time you pretended
to
be an engineer? Any first year student would understand frequency and
would
know that the OP was talking about how often a report is produced.

These newsgroups are provided by Microsoft for FREE peer to peer support.
Your type of help is not needed.

John... Visio MVP

Steve,
Sorry, but I got a little discourage with the help I was expecting from this
forum, due to personal attacks between the contributors of this site. I
decided to try elsewhere for support with my database. I am still working on
it and seem to be making some progress. Thank you for your input.
--
Thanks, for spreading the knowledge.
Raven


"Steve" wrote:

Raven,

Are you saying that you were not able to implement the tables I gave you?

Steve


"Raven" wrote in message
...
OK. I found that the previous setup information I was previously supplied
with did not work. Can someone please help me set up my tables, so that I
can
affectively create my forms. When I added all the IDs to my main table I
did
not know what to do with them on the forms.
I am starting from scratch.
--
Thanks, for spreading the knowledge.
Raven


"John... Visio MVP" wrote:

"Steve" wrote in message
m...

......... Don't know what frequency is ...........

Steve

Showing off the quality of your work? I thought at one time you pretended
to
be an engineer? Any first year student would understand frequency and
would
know that the OP was talking about how often a report is produced.

These newsgroups are provided by Microsoft for FREE peer to peer support.
Your type of help is not needed.

John... Visio MVP

Steve, I don't think my last attempt to post this message went through, as I
was kicked off my system. So, forgive the redundant message if the message
does post.

After my last post on 7/25, I got somewhat discouraged based on the insults
between two of the contributors of this site, and decided to seek support
with my database, elsewhere. I am still working on my database on making
some progress. Thank you for your input.

--
Thanks, for spreading the knowledge.
Raven


"Steve" wrote:

Raven,

Are you saying that you were not able to implement the tables I gave you?

Steve


"Raven" wrote in message
...
OK. I found that the previous setup information I was previously supplied
with did not work. Can someone please help me set up my tables, so that I
can
affectively create my forms. When I added all the IDs to my main table I
did
not know what to do with them on the forms.
I am starting from scratch.
--
Thanks, for spreading the knowledge.
Raven


"John... Visio MVP" wrote:

"Steve" wrote in message
m...

......... Don't know what frequency is ...........

Steve

Showing off the quality of your work? I thought at one time you pretended
to
be an engineer? Any first year student would understand frequency and
would
know that the OP was talking about how often a report is produced.

These newsgroups are provided by Microsoft for FREE peer to peer support.
Your type of help is not needed.

John... Visio MVP

"Raven" wrote

After my last post on 7/25, I got somewhat discouraged
based on the insults between two of the contributors of
this site, and decided to seek support with my database,
elsewhere.

That's fine, Raven, none of us is paid for answering questions in this
newsgroup. Steve, however, trolls the newsgroup to try to find paying work,
but his demonstrated knowledge of Microsoft Access is not such that users
should be paying him for it, especially since better assistance is
available, free, right here, and he has been know to hold the truth in low
regard.

Steve is not the poor, poor pitiful little victim that he pretends to be, so
you need not waste time sympathizing with him over "insults" -- one of the
insulters, if you'll check back in the thread was Steve.

I am still working on my database on making
some progress. Thank you for your input.

There are other sources of good information. You might try the "Utter
Access" site. I don't believe Steve is allowed to clutter the message
threads there.

Larry Linson
Microsoft Office Access MVP
(information on the Microsoft MVP program is at
http://mvp.support.microsoft.com --
you will not find Steve's profile on the list there, just FYI)