M
MD
Hi,
I have this application with 6 tables and many forms,
reports, quaries, etc. The application has been splitted
into a front-end and a back-end, with back-end being the
actual tables. THe application has been in use for the
past 6-months and one of the tables only has records in
it. Changes were requested and I have made the changes to
the application and also, to the relationships which
involves the table that has many records in it currently.
Now my question:
1- table which is in production has records in it.
2- changed table on my machine has no records but has to
be uploaded to replace the table in production.
3- Can I load the new and modified database and just copy
and past the data from the table in production to the one
just loaded?
4- if i import the table in production to my machine and
remane the same one on my machine,then how can I make the
imported table with the relationship that i have on the
application on my machine.
I don't know if I explain my question correctly or not,
forgive me if I have confused you. i guess my only
problem is the relationships. Application on my machine
has the wanted relationship ans has the changes requested
but one of the tables in production has data in it and I
don't know how this is going to work out.
Regards,
MD
I have this application with 6 tables and many forms,
reports, quaries, etc. The application has been splitted
into a front-end and a back-end, with back-end being the
actual tables. THe application has been in use for the
past 6-months and one of the tables only has records in
it. Changes were requested and I have made the changes to
the application and also, to the relationships which
involves the table that has many records in it currently.
Now my question:
1- table which is in production has records in it.
2- changed table on my machine has no records but has to
be uploaded to replace the table in production.
3- Can I load the new and modified database and just copy
and past the data from the table in production to the one
just loaded?
4- if i import the table in production to my machine and
remane the same one on my machine,then how can I make the
imported table with the relationship that i have on the
application on my machine.
I don't know if I explain my question correctly or not,
forgive me if I have confused you. i guess my only
problem is the relationships. Application on my machine
has the wanted relationship ans has the changes requested
but one of the tables in production has data in it and I
don't know how this is going to work out.
Regards,
MD