By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,084 Members | 1,956 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,084 IT Pros & Developers. It's quick & easy.

Synchronize between two tables in access

P: n/a
Hi,

I amnew to this group and lucky to have found this group. i have a
master table which has different types of application say Desktop,
Mainframes, etc.

I have an individual table for each of these application types.... one
for Desktop, one for mainframes, etc

How do i synchrinize data between these two tables, say i update the
Mainframe application description in Master table, it should get
updated in the Mainframe individual table.

TIA,
Pradeep

Aug 3 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Is the data you are keeping in these two tables something like AppName,
AppVersion, and AppDescription and one record would be
Access 2003 Relational database
If it is then I would have only one table and add a checkbox for Mainframe
and one for Desktop. Then when you enter the data you could check either or
both. If you needed a report on Mainframe applications, a query could pick
only mainframe records for your report, etc.

pradeep wrote:
>Hi,

I amnew to this group and lucky to have found this group. i have a
master table which has different types of application say Desktop,
Mainframes, etc.

I have an individual table for each of these application types.... one
for Desktop, one for mainframes, etc

How do i synchrinize data between these two tables, say i update the
Mainframe application description in Master table, it should get
updated in the Mainframe individual table.

TIA,
Pradeep
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200608/1

Aug 4 '06 #2

P: n/a
Thanks a lot for the help....will try this out and see if my problem
gets resolved....this is the first time i am working with access and
finding it much different from oracle..... :(

I had a single table earlier.....but people here want the data in
different tables so that they can modify or do any changes....if they
retrieve the info through a query...how do we manipulate them.....any
means by which we can modify data.

Say select * from Application_master where
Application_type="Mainframes"

all mainframe records are displayed.... there is a comments column...if
i need to add comments to that how do i add...they dont want to use
forms....they make decisions based on the whole query and enter
comments for individual applications.

Thanks again folks....this group rocks...
jahoobob via AccessMonster.com wrote:
Is the data you are keeping in these two tables something like AppName,
AppVersion, and AppDescription and one record would be
Access 2003 Relational database
If it is then I would have only one table and add a checkbox for Mainframe
and one for Desktop. Then when you enter the data you could check either or
both. If you needed a report on Mainframe applications, a query could pick
only mainframe records for your report, etc.

pradeep wrote:
Hi,

I amnew to this group and lucky to have found this group. i have a
master table which has different types of application say Desktop,
Mainframes, etc.

I have an individual table for each of these application types.... one
for Desktop, one for mainframes, etc

How do i synchrinize data between these two tables, say i update the
Mainframe application description in Master table, it should get
updated in the Mainframe individual table.

TIA,
Pradeep

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200608/1
Aug 4 '06 #3

P: n/a
pradeep wrote:
Thanks a lot for the help....will try this out and see if my problem
gets resolved....this is the first time i am working with access and
finding it much different from oracle..... :(
Sure Access is different from Oracle, but table design is a universal
(well, almost) concept (^:
>
I had a single table earlier.....but people here want the data in
different tables so that they can modify or do any changes....if they
retrieve the info through a query...how do we manipulate them.....any
means by which we can modify data.

Say select * from Application_master where
Application_type="Mainframes"
Sure, if Application_type is a column in Application_master. If you have
two tables like I described in my post yesterday you would use the
SELECT statement I wrote there, adding a WHERE clause like
WHERE Application_type="Mainframes"

The difference here is how many times do you want to store the value
'Mainframes'? In a related table design you store this value exactly
once. In your one table design, you store it as many times as you have
rows for mainframe applications.

You can update the value with a new description in either case using an
UPDATE query or a form.
>
all mainframe records are displayed.... there is a comments column...if
i need to add comments to that how do i add...they dont want to use
forms....they make decisions based on the whole query and enter
comments for individual applications.
You really must use a form. I mean, Access does not require it, but you
will avoid a lot of headache if you do. Surely you don't update tables
directly in Oracle. Tables are meant to store data. Forms are for
displaying and modifying the data. Access makes this easy. You create a
query to retrieve the data you want (include comments column here),
create a form that uses the query as it's record source, and you're up
and running in under 1 minute.

Is this helping?
>
Thanks again folks....this group rocks...
jahoobob via AccessMonster.com wrote:
>Is the data you are keeping in these two tables something like AppName,
AppVersion, and AppDescription and one record would be
Access 2003 Relational database
If it is then I would have only one table and add a checkbox for Mainframe
and one for Desktop. Then when you enter the data you could check either or
both. If you needed a report on Mainframe applications, a query could pick
only mainframe records for your report, etc.

pradeep wrote:
>>Hi,

I amnew to this group and lucky to have found this group. i have a
master table which has different types of application say Desktop,
Mainframes, etc.

I have an individual table for each of these application types.... one
for Desktop, one for mainframes, etc

How do i synchrinize data between these two tables, say i update the
Mainframe application description in Master table, it should get
updated in the Mainframe individual table.

TIA,
Pradeep
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200608/1

--
Smartin
Aug 4 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.