simple stuff - please help!

[fateyes]

Hi, any help appreciated...

At the moment I have quite a large database, not relational - just one big table!

In the future I should really figure out how to make it relational, but it just seems too complicated for me.

Anyway, for the moment I have two small problems:

1. I want to make the addresses in the Email address field clickable, so that a new message opens up in Outlook headed to that person. (I managed to do web hyperlinks but not this!!)

2. I just made replicas to be used around the office, and the synchronisation works fine. I tried to create a new Query in the design master, but only its form is marked as replicable, so when I synchronise the replicas do not understand the query - Do I have to recreate the replicas and save them over the existing ones?

Cheers,

Laurie

 

[y2k]

I don't have a definite solution unfortunately. I tried chaning the datatype to hyperlink but that doesn't seem to work for mailto: hyperlinks. Maybe somebody else knows how to do this? What you can do is change the datatype to hyperlink, select the text you want to act as a link and press CTRL + K, in the "type the file or web page..." enter mailto:me@myemail.net. I know it's not a solution, but maybe it's a start? Sorry I couldn't be more help.

Unfortunately I don't have a solution to your second problem at all!