Hi Everyone,
I hope someone can guide me.
here is my issue
I have a central database that is running in my back office and each of my front end machines have a database that is used just for the front end.
most of the data that is stored in the back office is not needed on the front end but the product table is.
the product table hold more information then what is needed on the front end (the front end system does not need to know who the supplier is of the item for example)
so I have the following feilds on the front end database (called posdatabase)
barcodenumber
posdeacription
pricetype
salelocation
Systemprice.
both database are using the same field names
is it possible to use replication on select Feilds on the master to the slave? I have seen on YouTube lots of videos showing replication of every table and field in a database but I don't need that)
what I want to do is that possible?
Thank you for your time with this matter
Andrew Gable
Owner / Software developer
algPoS,Northampton
http://www.algpos.co.uk
01604 289431
Send from iPhone Email.
This e-mail is private, confidential and is for the intended recipient only. If misdirected, please notify the sender by telephone and confirm, by return e-mail, that it has been deleted from your system and any copies destroyed. If you are not the intended recipient you are strictly prohibited from using, printing, copying, distributing or disseminating this e-mail or any information contained in or attached to it.