Newbies Tatty Posted July 25, 2011 Newbies Posted July 25, 2011 I am new to Filemaker so apologies if this query is a bit basic. I have a form based on a tblExpenses which contains transactional data. Within that table there is (for example) a field called CategoryID. This relates to a CatID field in a seperate tblCategories. What I want is a way on the original form that when the user tabs in, they can start typing the category description but be restricted to that values from tblCategories.The resultant value though needs to be stored as the ID (not the description) in the tblExpenses I've tried using drop downs and pop ups but this doesn't seem to meet the requirement. What I think I need is an edit box which auto completes against a value list from the tblCategories. I could do it by storing the descriptions (rather than IDs) in the table but this goes against what I've been taught about having unique numerical IDs for each category. Any ideas? Thanks in advance Tatty
efen Posted July 25, 2011 Posted July 25, 2011 I'm not really sure that I understand what you want. Will a drop down list of the categories not fit what you need - the user would not have to type anything then, just select from a list? Like the attached. expense_category.zip
Recommended Posts
This topic is 4878 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now