I seem to not understand the workings of this very simple thing:
I have two tables, customers, titles
customers
==============
customer_id
title_id
customer_lname
customer_fname
etc
titles
==============
title_id
title_text_fr
title_text_en
title_text_nl
Titles correspond to: Mr Miss Mrs (= values for title_text_en)
In a customer form, I am simply trying to display in a list box: Mr Miss Mrs while the value entered in the customers.title_id should be the corresponding id (1 for Mr etc).
I am sorry to bother with such an easy question, but seriously, I do not seem to manage to solve it.
I have tried a form, edited the field for list box, calculated values, selected the table but cannot manage to display the text and enter the id.
And what is the difference if any with fields rules ?
And also, as a side question, I have 5000+ entries in the customer table, and alpha seems to run pretty slow, is this normal ?
------------------------------------------
Before joking, read the background:
We specialize in programming online applications in lamp environment, since we have more and more clients requesting that we take care of their local systems, I am evaluating alpha (been through access and filemaker).
We mainly intend to use it as a local frontend to our databases (MySQL) while keeping our cms and online solutions.
Last year, following one of our client's request, we have sucessfully translated a (rather large and complicated) ms access database to MySQL while keeping their in-house frontend (developed over years by the client) but that road was not painless, and it is not very easy to get support from MS (rather impossible), not a problem with the MySQL folks, they are behind you and support is good.
We also evaluated Filemaker pro, but that is kind of a joke, they advertise a 'partnership' with MySQL but we are far from a perfect integration and support over here in Belgium is .... not efficient ... would be a nice way of putting it.
So we have good hope for Alpha five.
And this would explain why I am such a noob regarding syntax, scripting etc etc etc, I only have spent a few hours on it, but we have to make a fast decision.
The product pretty much convinced us anyway, and this 'problem' is not that important, we can always name the files properly and not even need to store their references, but this would be nicer 'user friendly wise'.
I have two tables, customers, titles
customers
==============
customer_id
title_id
customer_lname
customer_fname
etc
titles
==============
title_id
title_text_fr
title_text_en
title_text_nl
Titles correspond to: Mr Miss Mrs (= values for title_text_en)
In a customer form, I am simply trying to display in a list box: Mr Miss Mrs while the value entered in the customers.title_id should be the corresponding id (1 for Mr etc).
I am sorry to bother with such an easy question, but seriously, I do not seem to manage to solve it.
I have tried a form, edited the field for list box, calculated values, selected the table but cannot manage to display the text and enter the id.
And what is the difference if any with fields rules ?
And also, as a side question, I have 5000+ entries in the customer table, and alpha seems to run pretty slow, is this normal ?
------------------------------------------
Before joking, read the background:
We specialize in programming online applications in lamp environment, since we have more and more clients requesting that we take care of their local systems, I am evaluating alpha (been through access and filemaker).
We mainly intend to use it as a local frontend to our databases (MySQL) while keeping our cms and online solutions.
Last year, following one of our client's request, we have sucessfully translated a (rather large and complicated) ms access database to MySQL while keeping their in-house frontend (developed over years by the client) but that road was not painless, and it is not very easy to get support from MS (rather impossible), not a problem with the MySQL folks, they are behind you and support is good.
We also evaluated Filemaker pro, but that is kind of a joke, they advertise a 'partnership' with MySQL but we are far from a perfect integration and support over here in Belgium is .... not efficient ... would be a nice way of putting it.
So we have good hope for Alpha five.
And this would explain why I am such a noob regarding syntax, scripting etc etc etc, I only have spent a few hours on it, but we have to make a fast decision.
The product pretty much convinced us anyway, and this 'problem' is not that important, we can always name the files properly and not even need to store their references, but this would be nicer 'user friendly wise'.
Comment