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=]1,Integer,Varchar,Integer,Integer,Integer[/Table]
[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=]1,Integer,Varchar,VarChar,Integer,Double,Double[/Table]
[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
BrightRaven77
 
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.7 & LibreOffice 6.1.5.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 1278
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 4 guests