Need your help Urgently

[dinadvani via AccessMonster.com]

Hello All,

Please help me I am stuck while preparing a database.

1) Please let me know how one can define primary key, foregin key etc?
2) I have a 1 table that contains regn ID, Account name, Project Name and
many other information. Now to enter the information i have prepared a form
for this table.
I have another table which contains regn ID, account name, project name,
revenue id etc. For which i have form 2

Please let me know how is it possible to reduce the duplicate work. If I
enter the information in table 1 how can I get the information in form which
stores data in table 2.

If i select regn id in form 2 how can i auto populate only the account name
and project name.

Please Please help

 

[dinadvani via AccessMonster.com]

Please Help ASAP

Thanks a lot

Hello All,

Please help me I am stuck while preparing a database.

1) Please let me know how one can define primary key, foregin key etc?
2) I have a 1 table that contains regn ID, Account name, Project Name and
many other information. Now to enter the information i have prepared a form
for this table.
I have another table which contains regn ID, account name, project name,
revenue id etc. For which i have form 2

Please let me know how is it possible to reduce the duplicate work. If I
enter the information in table 1 how can I get the information in form which
stores data in table 2.

If i select regn id in form 2 how can i auto populate only the account name
and project name.

Please Please help

 

[Jeff Boyce]

Just so that you are aware, the folks who help out here are volunteers. If
your need is quite urgent, consider hiring assistance ...

From your description, both Table1 and Table2 have [regn ID], [Account Name]
and [Project Name] fields. While this might be necessary if you were using
Excel, it will make your work (and Access' work) much harder. One of the
basic notions of using a relational database is that you only need to record
data once.

In your example, you'd only need to record [Account Name] and [Project Name]
in one table, since you can "point" back to that information by using the
primary key of that table (?[regn ID]?).

Why do you believe you need to record the same facts more than once? That
is, what business need are you trying to solve by doing this?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[BigReg]

Not sure if you resolved your problem but try this: Create a query using the
following. they use that query for your record source.

SELECT Table1.[Account name], Table2.[project name], Table2.[revenue id]
FROM Table2 INNER JOIN Table1 ON Table2.[regn id] = Table1.[regn id];

BigReg

Just so that you are aware, the folks who help out here are volunteers. If
your need is quite urgent, consider hiring assistance ...

From your description, both Table1 and Table2 have [regn ID], [Account Name]
and [Project Name] fields. While this might be necessary if you were using
Excel, it will make your work (and Access' work) much harder. One of the
basic notions of using a relational database is that you only need to record
data once.

In your example, you'd only need to record [Account Name] and [Project Name]
in one table, since you can "point" back to that information by using the
primary key of that table (?[regn ID]?).

Why do you believe you need to record the same facts more than once? That
is, what business need are you trying to solve by doing this?

Hello All,

[quoted text clipped - 15 lines]

Please Please help