AnsweredAssumed Answered

Check box that changes the table fields reference.

Question asked by RyanHart_1 on May 7, 2012
Latest reply on May 7, 2012 by philmodjunk


Check box that changes the table fields reference.




I am new to filemaker pro but have some experience with MS Access and Excel.  I am learning FM pro 11 and want to know if something is possible as I build someting for a very patient client.

Essentially its very similar to the free filemaker pro starter solution called Invovice.

What currently happens is that the form for creating an invoice is fed of an existing table from customers.  My client has many walk in customers so having to complete the customer form efore the invoice form just doesn't make sense for him.    However, retaining notes and information regarding his existing customers is important (he is a hair dresser and need to keep track of cuts, photos, and hair dye solutions.) 

So my thought process led me to believe an easy solution would be to have the form change based on a check box.  The box will be called "walk in."  When checked he can popiate the fields on the invovice form and it updates the customer table, when unchecked the fields pull from the existing customer table.

Anyone have any thoughts on how I can make this happen?