Controls for Data import by Excel (1 Viewer)

[htadis]

Good day !

Seek your kind assistance on below;

Table name :TblMain
Field 1 : Bkg_Number (text)
field 2 : Container no (text)
Field 3 : Size (text)
Field 4 : Weight (number)

Table Name : TblBooking
Field 1 : Bkg_NUmber(text)
Field 2 : Customer (text)
field 3 : Vessel (text)
Field 4 : Voyage (text)
field 5 : Ttlcntrs (number)

First feeding data in the Tblbooking and creating a booking number. In the same time enters Total containers (ttlcntrs) for the booking. Then, importing some data to Tblmain by using Excel. Booking number is one of the columns importing. My question is, if number of records in the excel file, exceeds the number of total containers (Ttlcntrs) defined in the Booking table, error msg should be given and stop the import process.

How could this be done ? pls help.

brgds
Htadis

 

[JHB]

I've some trouble understanding what you mean, could you show some sample data and by which data you get the problem!