I'm using a table created from a custom SQL query reading table detail. I'd like to use a data entry form to dynamically scan the key data. Seems easy enough - but I can't figure out how to assign a query prompt or similar control to feed the table SQL.
Anyone have a similar issue? I've tried using template field data - but it seems like the DB table control calls the DB prior to the scan...and won't return data.
Please sign in to leave a comment.