ContributionsMost RecentMost LikesSolutionshow to I get the next empty related field from a related table I have a table (x) with fields (serial number, serial number assign date) and a second table (y) which is a child table wherein I need to automatically select the next available (where serial number assign date = null) serial number from (x). ------------------------------ Altaf Rawoot ------------------------------