help with database design

[mar7632]

Hi again,




I am developing a database which deals with the state of the projects

In the first database I have one table called "aa_DatosRecibidos". Among the fields I have [CodigoRFQ].

When [Código RFQ] is approved, then it is transfered to another Database which has 3 tables (T_codigoApproved (1 - 1) T_ProjectData (1-infinite) T_Phases )

My idea is to introduce in a form (in the second database) a comb box which looks up for one table´s record from the first database and when a button is clicked (confirming the operation) then transfer only that record. This comb box has to be designed to select the [CodigoRFQ] which is unique. And then, continue filling T_ProjectData and T_Phases data by using forms and subforms.

But, in my experience:

When building a database with all table´s relationships at the beggining. I have problem related to transfer data from an excel file to my access form which has a few tables in there. One of them received all the data from the excel and the other tables were used to introduced information manually. However, It seemed that the id´s field from the other tables did not update when exporting the information from Excel. But it works when the data is written by hand.

So, how do I design this second database in order to be functional?
Is it possible to build this comb box in order to select by [CodigoRFQ] a certain record and import it to the second database?

Thank you in advance.

[isladogs]

Suggest you research Referential Integrity which is used to keep tables synchronised

[mar7632]

Ok, thank you for your reply.
Do you know the second question? To select a field from another database and copy all the record into the new database?

[alansidman]

see my response to your other post on this matter

https://www.accessforums.net/showthread.php?t=76691

[mar7632]

Thank you again for your response

Okay, So in order to send all the information I will use the code provided in this post (which I tested and works) https://www.accessforums.net/showthread.php?t=76691

How do I transfer the data from one database to another?

Thank you in advance.

[orange]

mar7632,
I recommend that you step back and describe to readers:
-an overview of the business you are trying to support with this proposed database in simple, clear terms
-a brief description of these different databases you reference
-a description of the excel file and how it fits into the "bigger picture".

Relationships in database are a reflection of the rules/facts within the business.
For example, a Customer may have 1 or Many Orders.

See the Database Planning and Design link in my signature for more info.

Good luck with your project.