Suggestion improvements features base

Discuss the database features

Suggestion improvements features base

Postby BrightRaven77 » Thu Nov 07, 2019 5:06 pm

could u link in table creation on format example to an SQL Script
for example
Table tblCountries
[Table=]2,CountryID, Country, AccountFormat, TaxFormat, AccountValue[/Table]
[Table=]3,1,Belgium,"BE"00 0000 0000 0000, "BE-"000”.”000”.”000,97 [/Table]

Table tblSuppliers
[Table=]2, SupplierID, supName, supAdres, supCounty, supAccount, supTaxN°[/Table]
[Table=]3,1, Anonyme, , 1, BE00 0000 0000 0000,BE-000.000.000[/Table]

for subAccount format would then be linked as:
Select AccountFormat
From tblCountries as con
Where CountryID = ActiveRow.supCountry
openoffice 4.17, windows 10
Posts: 1
Joined: Thu Nov 07, 2019 2:43 pm

Re: Suggestion improvements features base

Postby UnklDonald418 » Thu Nov 07, 2019 11:56 pm

Welcome to the forum.
I'm not sure I entirely understand your question, but see if this helps Validity/Conditional Drop Down Lists in Base
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.6 & LibreOffice - Windows 10 Professional
Posts: 1322
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Return to Base

Who is online

Users browsing this forum: No registered users and 5 guests