Recent content by Nonnylizing

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