Search results

Thank you and God's blessings

Why is nobody talking to me... Have committed a crime? Have violated the forum rules and regulations? Have I insulted anybody? Is it a crime that I learned step 1 and then try to achieve step 2 on my own using step1? Can't somebody try to push for further answers using the one he learnt...

In my Permit type as earlier stated,(Bus, tricycle, mass transit, taxi, etc), Bus and Tricycle are further Divided in to Routes (for bus) and province (for tricycle) as follows; Buses: R-01, R-02, R-03....R-10 indicating Route 1 to 10 Tricycle: NKW, NSK, UDE, etc indicating abbreviations for the...

ok ... tatanungin ko

But.....can I ask you one more question? Pleeeeeeeease 🙏

Love you man.... it's working

Sorry

You said...add column to "your combo" Which combo pls? Do you mean the Permit_type combo box? If yes, then the source of the drop-down is not from a different table but rather from the "I will type in the values that I want" of the Lookup Wizard....what do I do exactly

😂😂 One step at a time sir....pls don't be offended

It worked!! and saving too 🌹 Thank u sir... but then I need another manipulations... In one of my combo boxes, there's one named permit_type with contents Buses Tricycle Taxi etc The fleet numbers are assigned according to permit type thus Buses. "MOT/R/[SN] Tricycle. "MOT/T/[SN] Taxi...

Trust me sir, I need to store them in the main database table....if I can't handle the manipulation, then I'll have to manually input the FleetNo... though it will prolong my entry time.... But then @theDBguy promised he'll do something so I'm patiently waiting for him

Ok.... but then I think you should know that it actually saves new record, both SN and fleetNo in the query but only save SN in the table....the fleetNo field in the table still remain blank

Tell me how please

It auto-generated but when I save, record is not seen anywhere

Yes but through a form

It generated the fleetNo field

I'm a little bit confused cos my main database table already contained serialNo field and FleetNo field And my Form also contain the SerialNo textbox and fleetNo textbox bound to theirs respective fields in the database table Help me relate the two textboxes so that if I enter values in textbox...

No year...just MOT/T/SerialNo

Nationality States Cities ..all depends on each other Now I have 3 tables for each of them from where I derived the inputs for my cascading combo boxes I still have tblPermitType (taxi, buses, mass transit) tblRoute From where I derived the inputs for PermitType and Route cascading combo boxes...

@jdraw , @Ranman256 and @The_Doc_Man Let's forget the terminologies that I used... may be confusing but this is what I want... I want to reduced the time of inputs and the possibility of mistakes in my fleet number column which is an alphanumeric value The serial number corresponds to the...