If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Need your help Urgently
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 -- Message posted via http://www.accessmonster.com |
#2
|
|||
|
|||
Need your help Urgently
Please Help ASAP
Thanks a lot dinadvani wrote: 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 -- Message posted via http://www.accessmonster.com |
#3
|
|||
|
|||
Need your help Urgently
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 http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ Microsoft Registered Partner https://partner.microsoft.com/ "dinadvani via AccessMonster.com" u22798@uwe wrote in message news:6aaf6ecdd056e@uwe... 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 -- Message posted via http://www.accessmonster.com |
#4
|
|||
|
|||
Need your help Urgently
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 Jeff Boyce wrote: 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 |
Thread Tools | |
Display Modes | |
|
|