newday

I have a script that does the following: - show all records - sort by date (so most current date is last) - go to last record and date field Now, based on the contents of that date field, I want to do a second FIND to return all records with that date. (The reason... sometimes we do our billing and need to unmark the most current billing print date for various reasons. I would be adding the script to a button so anyone can do it without having to call me).

Figured it out - no reply needed

I have 4 tables in my database. Of those, several are used in a relationship in each table for multiple lookups. (For example: Client_Code, Client_Name, Client_Type, Client_Cost are in two or more tables with different types of data). Rather than having to go into each screen and enter the same data, is there an easy way to make a single screen that will put the data into each table?

Thanks - the brain just wasn't working. This is the answer I was looking for.

I need to be able to insert a price based on the contents of 3 fields. Field one is client. Field two is type. Field three is Format. (Type refers to a Tape Dub Type such as Edit, OTO Edit, Dub). (Format refers to a tape size such as VHS, DVD, BSP, 1"). We have 30+ clients, 4 Types, and 8 Formats). Each client has their own pricing based on what is being done and onto what format it is being copied. See attached PDF file for tables and relationships. (The main page is called BDV, the rest are look up tables). If I enter client XXX on the BDV Page, select the Dub_Type and the Format from pulldown menus, I need to have the correct price fill in. Relationships.pdf